Database Operation of python
1. Insert data
Import MySQLdb
# create a connection
Conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='123456',db='test')
Cur = conn.cursor ()
# execute execution in the form of% s to prevent sql injection
ReCount = cur.execute ('insert INTO test1 (name,country,age,address) VALUES (% sdepartment% s)% s)', ('2)
''
# another way of writing
Sql = "insert INTO test1 (name,country,age,address) VALUES (% SJM% SJ% SJO% s)"
Params = ('2i, no, no)
ReCount = cur.execute (sql,params)
''
# submit
Conn.commit ()
# close the connection
Cur.close ()
Conn.close ()
Print reCount
two。 Update the database
Import MySQLdb
# create a connection
Conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='123456',db='test')
Cur = conn.cursor ()
Sql = "update test1 set address =% s where id = 2"
# add a comma to indicate a sequence
Params = ('BeiJing',)
ReCount = cur.execute (sql,params)
# submit
Conn.commit ()
# close the connection
Cur.close ()
Conn.close ()
Print reCount
3. Find data
Import MySQLdb
# create a connection
Conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='123456',db='test')
Cur = conn.cursor ()
Sql = "select * FROM test1"
ReCount = cur.execute (sql)
# display the data found, and the results are displayed in the form of a dictionary
Print cur.fetchall ()
# close connection cur.close ()
Conn.close ()
Print reCount
4. Delete data
Import MySQLdb
# create a connection
Conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='123456',db='test')
Cur = conn.cursor ()
Sql = "delete FROM test1 WHERE id = 2"
ReCount = cur.execute (sql)
# submit
Conn.commit ()
# close the connection
Cur.close ()
Conn.close ()
Print reCount
