5 - Basic SQL Queries with PythonAnywhere using a MySQL database
Executing basic SQL queries in the PythonAnywhere's console/terminal. SELECT queries specifying columns AS alias columns, ORDER BY, LIMIT, LIKE, OR operator and even creating a numbered column using a NUMBER_ROW( ) emulation technique for older versions of MySQL. A Great way to learn SQL in the cloud for online learning environments.
Link to W3schools SQL Tutorial:
https://www.w3schools.com/sql/
Link to ROW_NUMBER() Code:
https://www.mysqltutorial.org/mysql-r...
Snippet of Actual Code used in video:
SET @row_number = 0;
SELECT
(@row_number:=@row_number + 1) AS num,
On this page of the site you can watch the video online 5 - Basic SQL Queries with PythonAnywhere using a MySQL database with a duration of hours minute second in good quality, which was uploaded by the user homastudio 01 September 2020, share the link with friends and acquaintances, this video has already been watched 2,101 times on youtube and it was liked by 30 viewers. Enjoy your viewing!
