import MySQLdbconn = MySQLdb.connect(host=”localhost”,user=”root”,passwd=”“,db=”mytest”,charset=”utf8”)cursor = conn.cursor()sql=”select * from xxx where xx=%s” : Set to upload sql sentence key=” Fill in the blanks ”param = (key) : Set up param,key It's a variable. ,param by sql Statement %scursor.execute(sql,param) : Upload sql Statement and paramconn.commit() : Carry out orders n = cursor.fetchall() :n To get all the returned content Is a two-dimensional array ,n[i][j]for data in cursor.fetchall()print ‘%s’%data : Show results fetchone() : Get the next row of the result set fetchmany() : Get the next few lines of the result conn.close() : Close the connection conn.rollback() : Roll back , Cancel current transaction crant all on Database name .* to users : Give permission to a user , Add S It's all users use test : Select database to use drop database Database name : Delete database create table Table name (login varchar(8),uid int ,prid int) : Create table drop table Table name : Delete table insert into Table name values( value 1, value 2, value 3…) : Insert row update Table name set Field 1=xxx where Field 2=xxx : Update table 

1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.


1.