需求:现在流行一个技术为将mysql数据库中表格导出给excel去用,那么如何实现呢?
实现过程:
[root@client1 ~]# mysql -uroot -p123456
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| aaa |
| ccc |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql> use aaa;
mysql> show tables;
+---------------+
| Tables_in_aaa |