Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.