Python学习札记

Ubuntu平台下的Python操作Mysql
1.安装Ubuntu,安装Msql.
2.打开终端,输入 python
import MySQLdbcon = MySQLdb.connect(db="python")cur = con.cursor()count = cur.execute("select * from test")print countdata = cur.fetchall()print datafor d in data: print dimport osos.system('clear') # clear screencount = cur.execute("delete from test where id =1")print countcount = cur.execute("select * from test")print countcur.close()con.commit()con.close()

ps.python学习书籍
1.python简明教程
  http://www.woodpecker.org.cn:9081/doc/abyteofpython_cn/chinese/
2.python核心编程(第二版)