如何将mysql数据导到excel
如何将mysql数据导到excel，有什么工具吗？
问题点数：20、回复次数：4Top
1 楼sjt3749（sjt3749）回复于 2005-11-05 21:35:13 得分 0
1。先导到文本文件中
select ...... into outfile 'path\\filename' from ...... where .....
2。在将文本导入excelTop
2 楼hy2003fly（）回复于 2005-11-06 09:08:37 得分 0
可以用mysql-front和mysql query browser来导出Top
3 楼powerly（豆豆）回复于 2005-11-07 14:47:28 得分 0
用office里的access
1，打开access 右健-〉import 弹出对话框 选择 odbc （文件类型）
2，配置odbc 的信息
3，选择mysql里的表
4，打开
5，save as
over
Top
4 楼mathematician（数学家）回复于 2005-11-07 14:56:57 得分 0
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\chengang>cd\
C:\>cd mysql/bin
C:\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-nt
Type '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>Top
