awk '{print "insert into table1 vaules($1,$2);"}' outfile.txt >t1.sql mysql dbname<t1.sql
select aa,cc into table1 from src_table;
工具啦,我会,多省事!初学mysql,语句还不会 呵呵!学习
#假设上面文本文件中内容如下: (第一列是整型,第二列是字符型) #文件存放在d:\test.txt 11,"22" 33,"44"--导入数据到表中指定列 LOAD DATA INFILE 'd:\\test.txt' INTO TABLE table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (AA,CC)
mysql dbname<t1.sql
#文件存放在d:\test.txt
11,"22"
33,"44"--导入数据到表中指定列
LOAD DATA INFILE 'd:\\test.txt' INTO TABLE table1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (AA,CC)