1。先导到文本文件中
select ...... into outfile 'path\\filename' from ...... where .....
2。在将文本导入excel
select ...... into outfile 'path\\filename' from ...... where .....
2。在将文本导入excel
解决方案 »
- 求sql语句
- 求个存储过程
- mysql数据库的分离与附加
- 跪求,对“内部查询”和“外部查询”两个术语的详解!
- postgresql8.0在windows上的创建与启动
- mysql 提示 fails to start the services,please wait 30 seconds to try again?是什么问题
- Linux下MySQL数据导出问题.
- 请问MySQL的性能和允许存储的数据大概为多少.来者有分
- shuixin13(犬犬(心帆))!如何查看mysql的版本?
- 我在用MYOLEDB操作ASP.NET+MYSQL时,添加及修改操作都不接受中文,都出错了,英文数字都可以的,是为什么?
- 求MYSQL的使用教材
- 查找表中记录总条数的SQL语句处理问题
1,打开access 右健-〉import 弹出对话框 选择 odbc (文件类型)
2,配置odbc 的信息
3,选择mysql里的表
4,打开
5,save as over
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\chengang>cd\C:\>cd mysql/binC:\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.10a-beta-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| 51haha |
| aaa |
| bbs |
| mysql |
| phpwind |
| pt |
| test |
+--------------------+
8 rows in set (0.01 sec)mysql> use aaa;
Database changed
mysql> show tables ;
+---------------+
| Tables_in_aaa |
+---------------+
| a1 |
| aaa |
| aaaaa |
| b |
| b1 |
| ca |
| child_book |
| d |
| family |
| father_book |
| item |
| kiss |
| mather_book |
| publish |
| tablea |
| tableb |
| test |
+---------------+
17 rows in set (0.00 sec)mysql> select * from aaa;
+------+----+
| data | id |
+------+----+
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
+------+----+
3 rows in set (0.02 sec)mysql> select * from aaa into outfile 'd:\\aa.csv' fields terminated by ',' encl
osed by '"';
Query OK, 3 rows affected (0.03 sec)mysql>