1。先导到文本文件中
select ...... into outfile 'path\\filename' from ...... where .....
2。在将文本导入excel
select ...... into outfile 'path\\filename' from ...... where .....
2。在将文本导入excel
解决方案 »
- mysql求某段时间内的平均值问题求砖家指教.
- 判断有顺序的一组数中,是否有连续n个数均为正?急急急
- 我昨天用着还是好好地,可是到了今天mysqlfront一直说连接不到本地服务器
- 现在要如何写sql才能实现 event的主键 不在event2里面 的 所有记录
- .net连接MySql连接不能释放的问题
- 请问重起mysql的命令是什么?
- MySQL-Front里的复制数据库和数据表的功能为何无法使用
- 请帮我解释一下MySQL的表格类型。谢谢!也算送分。:)
- mysql认证
- 大侠救急:如何在Redhat Linux7.2下配置php4和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>