load data infile 问题

[wudaoshengu]

select * into outfile 'u.txt' fields terminated by ',' enclosed by '[]' from t3;


load data infile 'u.txt' fields terminated by ',' enclosed by '[]' into t3; //语法错误。

哪里出错，望指教！

[fcoolx]

enclosed by '[]'
只支持单字节，你这是两个字节了

[wudaoshengu]

select * into outfile 'u.txt' fields terminated by ',' enclosed by '+' from 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;
也是语法错误。
到底是哪里错了？

[wudaoshengu]

load data infile 'v.txt' into table t3 fields terminated by ',' ;

[wudaoshengu]

load data infile 'u.txt' into table t3 fields terminated by ',' enclosed by '+' lines terminated by '\r\n';
这样才正确。