可否在导入数据的同时创建一个新表？

sunnyfun

注意我这里的回车，根据需要自己修改吧。

CREATE DATABASE IF NOT EXISTS test; USE test; SET @a=LOAD_FILE('/1.txt'); SET @a=LEFT(@a,INSTR(@a, "\n")); SET @a=REPLACE(@a,"\t"," CHAR(10),"); SET @a=REPLACE(@a,"\r"," CHAR(10)"); SET @a=CONCAT("CREATE TABLE testtable (",@a,")"); DROP TABLE IF EXISTS testtable; PREPARE stmt FROM @a; EXECUTE stmt; LOAD DATA INFILE '/1.txt'   INTO TABLE testtable   FIELDS TERMINATED BY "\t"   LINES TERMINATED BY "\r\n"   IGNORE 1 LINES; SELECT * FROM testtable;