Python如何链接MySQL？

1、安装

2、使用

1. #!/usr/bin/python

2. importMySQLdb

3. 
   

4. db =MySQLdb.connect(host="localhost",# your host, usually localhost

5. user="john",# your username

6. passwd="megajonhy",# your password

7. db="jonhydb")# name of the data base

8. 
   

9. # you must create a Cursor object. It will let

10. # you execute all the queries you need

11. cur = db.cursor()

12. 
    

13. # Use all the SQL you like

14. cur.execute("SELECT * FROM YOUR_TABLE_NAME")

15. 
    

16. # print all the first cell of all the rows

17. for row in cur.fetchall():

18. print row[0]

3、高级用法

1. import peewee

2. from peewee import*

3. 
   

4. db =MySQLDatabase('jonhydb', user='john',passwd='megajonhy')

5. 
   

6. classBook(peewee.Model):

7. author = peewee.CharField()

8. title = peewee.TextField()

9. 
   

10. classMeta:

11. database = db

12. 
    

13. Book.create_table()

14. book =Book(author="me", title='Peewee is cool')

15. book.save()

16. for book inBook.filter(author="me"):

17. print book.title

18. 
    

19. Peeweeis cool