select * into outfile 'u.txt' fields terminated by ',' enclosed by '[]' from t3;
load data infile 'u.txt' fields terminated by ',' enclosed by '[]' into t3; //语法错误。哪里出错,望指教!
load data infile 'u.txt' fields terminated by ',' enclosed by '[]' into t3; //语法错误。哪里出错,望指教!
只支持单字节,你这是两个字节了
load data infile 'u.txt' fields terminated by ',' enclosed by '+' into table t3;还是语法错误 error:1064
select * into outfile 'v.txt' fields terminated by ',' from t3;
load data infile 'v.txt' fields terminated by ',' into table t3;
也是语法错误。
到底是哪里错了?
这样才正确。