- 论坛徽章:
- 0
|
感觉放在程序里处理比较合适，以下代码理论意义大于实际意义：
注意我这里的回车，根据需要自己修改吧。
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;
|
|
|
免费注册
发表于 2007-11-17 23:31
