SQL Part2 Python IDLE with MySQL
Create Databases, Tables, populate the tables, Select, Update, Delete, Create Users on the MySQL server, Grant and revoke privileges
Check out SQL Part-1
• SQL Part1- Introduction to Databases ...
To download MySQL
https://dev.mysql.com/downloads/mysql/
Some Codes for you to copy and work on your own computer (these can't be executed on the online platform)
CREATE DATABASE
http://tpcg.io/6bIf5n2e
CREATE TABLE
http://tpcg.io/70j6GRfQ
INSERT INTO table
http://tpcg.io/H1Q5WAmU
Output all records from a table using fetchall()
http://tpcg.io/dRAsbRJ2
Output one record from a table using fetchone()
http://tpcg.io/ndBihWHx
UPDATE and check with rowcount
http://tpcg.io/y85q4wgQ
DELETE and check with rowcount
http://tpcg.io/7XKf7GbK
GRANT ALL PRIVILEGES
http://tpcg.io/ufoi54PT
REVOKE ALL PRIVILEGES
http://tpcg.io/4LKUey6P
Commands for JupyterLab with SQLite
http://tpcg.io/xsjXDje9
