½T»{MySQL Using Connector/Python³s½u¦¨¥\

heavenweaver

¦³Ãö Connecting to MySQL 5.6 Using Connector/Python¥i¥H°Ñ¦ÒMySQL Connector/Python Developer Guide¡A¦bChapter 5 Connector/Python Coding Examples¦³¡G
5.1 Connecting to MySQL Using Connector/Python
5.2 Creating Tables Using Connector/Python
5.3 Inserting Data Using Connector/Python
5.4 Querying Data Using Connector/Python
´N5.1 Connecting to MySQL Using Connector/Python³¡¥÷¡A»¡©ú¤å¥óÁö¦³´£¨Ñ½d¨Ò¡A¦ý§ÚÁÙ¬O¨Ì·Ó¦Û¤vªº»Ý­n§@¨Ç­×§ï¡A©Î¥i¨Ñ«áÄòªº¤H°Ñ¦Ò¡A³s½u´ú¸Õ½d¨Òµ{¦¡¦p¤U¡G

1. import mysql.connector
   
2. from mysql.connector import errorcode
   
3. 
   
4. try:
   
5.   cnx = mysql.connector.connect(user='root', password='http://forum.twbts.com',
   
6.                               host='127.0.0.1',
   
7.                               database='world')
   
8. except mysql.connector.Error as err:
   
9.   if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
   
10.     print("Something is wrong with your user name or password")
    
11.   elif err.errno == errorcode.ER_BAD_DB_ERROR:
    
12.     print("Database does not exists")
    
13.   else:
    
14.     print(err)
    
15.     exit(1)
    
16. else:   
    
17.   print("Congratulation! Your Connector/Python Installation is Verified.")  
    
18.   cnx.close()

½Æ»s¥N½X