Connect to MySQL using MySQLdb in Python

First of all, the environment required for installation is not mentioned in Mysql and Python.

MySQLdb is installed.

Free in http://linux.bkjia.com/

The username and password are both www.bkjia.com

The specific download directory is/pub/2011/08/26/Python. Use MySQLdb to connect to MySQL/MySQLdb/

If Ubuntu is used, run sudo apt-get install python-mysqldb directly. After the installation is complete, test it in the Python interpreter and enter

Import MySQLdb # case sensitive !! If no error is reported, the installation is successful and may continue.

First, write the simplest one to create a database:

1. #! /Usr/bin/env python
2. # Coding = UTF-8
3. ImportMySQLdb
5. # Establish a connection to the Database System
6. Conn = MySQLdb. connect (host ='Localhost', User ='Root', Passwd ='Longforfreedom')
8. # Retrieve operation cursor
9. Cursor = conn. cursor ()
10. # Execute SQL to create a database.
11. Cursor.exe cute ("Create database python """)
13. # Close the connection and release resources
14. Cursor. close ();

Create databases, create tables, insert data, and insert multiple data records

1. #! /Usr/bin/env python
2. # Coding = UTF-8
3. ImportMySQLdb
5. # Establish a connection to the Database System
6. Conn = MySQLdb. connect (host ='Localhost', User ='Root', Passwd ='Longforfreedom')
8. # Retrieve operation cursor
9. Cursor = conn. cursor ()
10. # Execute SQL to create a database.
11. Cursor.exe cute ("Create database if not exists python """)
13. # Selecting a database
14. Conn. select_db ('Python');
15. # Execute SQL to create a data table.
16. Cursor.exe cute ("Create table test (id int, info varchar (100 ))""")
18. Value = [1,"Inserted? "];
19. # Insert a record
20. Cursor.exe cute ("Insert into test values (% s, % s )", Value );
22. Values = []
23. # Generating insert parameter values
24. ForIInRange (20):
25. Values. append (I,'Hello mysqldb, I am recoder'+ Str (I )))
26. # Insert multiple records
27. Cursor.exe cute.pdf ("Insert into test values (% s, % s )""", Values );
29. # Close the connection and release resources
30. Cursor. close ();

The query process is similar to the insert process, but there is only one more step to get the query result.
 

1. #! /Usr/bin/env python
2. # Coding = UTF-8
4. ImportMySQLdb
6. Conn = MySQLdb. connect (host ='Localhost', User ='Root', Passwd ='Longforfreedom', Db ='Python')
7. Cursor = conn. cursor ()
8. Count = cursor.exe cute ('Select * from Test')
9. Print 'Total % s record records', Count
11. # Obtain a record. Each record is returned as a tuples.
12. Print "Get only one record :"
13. Result = cursor. fetchone ();
14. PrintResult
15. # Print 'id: % s info: % s' % (result [0], result [1])
16. Print 'Id: % s info: % s'% Result
18. # Obtain five records. Note that the cursor has pointed to the second record because fetchone () was previously executed, that is, all records starting from the second record.
19. Print "Get only five records :"
20. Results = cursor. fetchtasks (5)
21. ForRInResults:
22. PrintR
24. Print "Get all results :"
25. # Reset the cursor position. The value 0 indicates the offset. mode = absolute | relative. The default value is relative,
26. Cursor. scroll (0, Mode ='Absolute')
27. # Getting all results
28. Results = cursor. fetchall ()
29. ForRInResults:
30. PrintR
31. Conn. close ()