使用load命令:
load data infile 'driver.txt' into table driver fields terminated by ',' enclosed by '"';
使用mysqlimport实用程序:
mysqlimport --fields-terminated-by=, --fields-enclosed-by=\" phptest driver.txt
load data infile 'driver.txt' into table driver fields terminated by ',' enclosed by '"';
使用mysqlimport实用程序:
mysqlimport --fields-terminated-by=, --fields-enclosed-by=\" phptest driver.txt
忘记加入database