Python tutorial 97 -- MySQL operation of Python database

Database operations generally refer to adding, deleting, modifying, and querying .

1、 Create a table in the database ：

2、Python MySQL Insert  (Python MySQL insert) 

3、Python MySQL choice  (Python MySQL select) 

Other codes are as follows ：

# Python MySQL to update (Python MySQL update)
updateSql = "UPDATE Artists SET NAME= 'Tauwang' WHERE ID = '1' ;"
cursor.execute(updateSql）
# Python MySQL Delete (Python MySQL delete)
deleteSql = "DELETE FROM Artists WHERE ID = '1'; "
cursor.execute(deleteSql )
# Python MySQL Example – Delete table (Python MySQL Example – Drop Table)
dropSql = "DROP TABLE IF EXISTS Artists;"
cursor.execute(dropSql)

  The above is Python Yes mysql Basic operation of database .