Python connection operation MySQL Database

　　

Development Database Program Flow:

1. Create a Connection object to get the cursor

2. Execute SQL using the cursor

3. Use the cursor to get the data, judge the execution status

4. Committing a transaction or rolling back a transaction

Import

Database Connection object: Connection

Database Interaction object: Cursor

2. #sql查询语句
4. Sql=' select * from user '
6. #sql语句执行
8. Cursor.execute (SQL)
10. #获取返回数据总条数
12. Rs=cursor.rowcount
14. Print RS
16. #获取返回的第一条数据, when the cursor rownumber=0, gets =1
18. Rs=cursor.fetchone ()
20. Print RS
22. #获取返回数据的接下来3条数据, when the cursor rownumber=1, gets =4
24. Rs=cursor.fetchmany (3)
26. Print RS
28. #获取剩下的所有返回数据, at which time the cursor rownumber=4, gets after = Last bar
30. Rs=cursor.fetchall ()
32. Print RS
34. #循环获取, process each piece of data
36. For row in RS:
38. print ' userid=%s username=%s '% row
40. Cursor.close ()
42. Conn.close ()

Python connection operation MySQL Database