大家好,我有一个文本文件,想制作脚本将其插入数据库。文本如下(示例行):01月1日,我的朋友们。文本以制表符分隔。非常感谢!
# 回答1 下面是一个示例:
- import MySQLdb
- db = MySQLdb.connect(passwd="something",db="whatever")
- c = db.cursor()
- c.execute(
- """INSERT INTO tablename (First_Name,Middle_Name,Last_Name,Month,Day,
- Year,Gender,Address,City,Pin,State,Phone)
- VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)""",
- (fn,mn,ln,month,day,year,gender,add,city,pin,state,phone))
要将数据放入列表:
- >>> s = "01O\t1\t1\tHapo\tmwanzo\tMungu\taliziumba\tmbingu\tna\tnchi"
- >>> s.split()
- ['01O', '1', '1', 'Hapo', 'mwanzo', 'Mungu', 'aliziumba', 'mbingu', 'na', 'nchi']
- >>>