mysql_python

最近又用了下mysql_python(下载在http://sourceforge.net/projects/mysql-python)
看看文档还不是很难,简单试了下
1.import MySQLdb
2.conn = MySQLdb.connect(host = 'localhost', user = 'root', passwd = '1234', db = 'db')  #====> 建立数据库连接
3.c = conn.cursor()
4.c.execute("LOAD DATA LOCAL INFILE 'c:/downloads/abc.csv' INTO TABLE `test` FIELDS TERMINATED BY '/t' LINES TERMINATED BY '/n'")  # ===========>这里要注意Windows下的路径也用正的斜杠
5.conn.commit() #====>提交上面的执行命令否则上面的命令不会起任何作用 也可以把第4行写成print c.execute("LOAD DATA LOCAL INFILE 'c:/downloads/abc.csv' INTO TABLE `test` FIELDS TERMINATED BY '/t' LINES TERMINATED BY '/n'") 方面查看进度