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; //语法错误。哪里出错,望指教!
解决方案 »
- mysql所有的数据库后缀为*.MYD大小都为0,怎么回事?
- SQL语句
- 问个mysql菜鸟问题
- mysql中修改字段值某几位
- Windows 2003下的ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
- delphi中的mysql的连接问题
- win98,mysql怎样支持中文?
- c++ 【连接】【mysql】
- access数据库如何转化为mysql?
- mysql的存储过程中如何在update修改表时,同时修改后的值返回到指定的参数中?
- 200分,怎样进行某一个字段实现中英文混合排序,,,,
- Mysql门外汉求教【长字符串数据】导入的一些问题
只支持单字节,你这是两个字节了
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;
也是语法错误。
到底是哪里错了?
这样才正确。