Skip to content

Latest commit

 

History

History
32 lines (18 loc) · 628 Bytes

File metadata and controls

32 lines (18 loc) · 628 Bytes

PythonMySQL

Note: You can use uppercase or lowercase letters


pip install mysql-connector-python 

Part1 Creation:

-Create DataBase: Use to create database

-Create Table: Use to create tables

-Insert Into Table: Use to insert to tables

-Delete From: Use to delete data from tables

-Drop Table: Use to detelte tables

-Update Table: Update data in table

Part2 Query:

-Select From: Query data from table

-Where: Condition for filtering data in query(same 'if' in programing)

-Order by: Use to sort data

-Limit: Limit return result from query

-Join: Use tocombine