linux下的mysql 表是utf8,导出的txt能不能是ucs2的(支持多国语言),我看了下导出都是ANSI编码方式
解决方案 »
- 求助,有关asp,mysql数据库查询语句语法的。
- 一段MSSQL的表记录批量更新的,如何写成MYSQL的语句 谢谢 有示例
- 数据从access迁移到mysql的一些问题
- mysql安装问题 unpacking of archive failed on。。
- MySql 记录,乱码。。从服务器上提交的汉子,是?号?
- mysql从另一台机子复制整个数据库到这台,表不能用,有什么方法吗?
- 不能创建数据库 “Access denied for user:'@locathost' to database 'project' ”
- 请问怎样查看MYSQL版本?
- 我的MySQL学习笔记(一)
- 怎么用select查询多个结果?
- 求一条sql语句
- 使用Navicat for MySQL 把root 权限点没有了~
select * into outfile ".\test.txt" fields terminated by ',' from tablename;是不是有其他参数?
select * into outfile "d:\\test2.txt" CHARACTER SET 'ucs2' fields terminated by ',' from test ;
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name'
[CHARACTER SET charset_name]
export_options
| INTO DUMPFILE 'file_name'
| INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]