Connect Python to the MySQL database and pythonmysql Database

Connect Python to the MySQL database and pythonmysql Database

 Connect to the MySQL database

Source code:

Import MySQLdb # import the MySQLdb Module

Print 'connect to the database </br>'

# Connect to the MySQL database

# If 'localhost' is entered in the host field and an error is returned, try '2017. 0.0.1'

Db = MySQLdb. connect (host = '127. 0.0.1 ', user = 'root', passwd = 'Michael', db = 'test ')

# Get database cursor get the database cursor

Cur = db. cursor ()

# Execute the SQL statement

R=cur.exe cute ('select * from people ')

# Get query results get all the results selected

R = cur. fetchall ()

# Output query results

Print 'output database query result: </br>'

Print r

# Close the cursor

Cur. close ()

# Close database connection close the database connection

Db. close ()

Appendix: differences between raw_input and input in Python