Mysql中如何批量生成脚本
Welcome to the MySQL monitor. Commands end with ; or \\g.
Your MySQL connection id is 3 to server version: 5.1.26-rc-log
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use information_schema
+---------------------------------------+
| Tables_in_information_schema |
+---------------------------------------+
| CHARACTER_SETS |
| COLLATIONS |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS |
| COLUMN_PRIVILEGES |
| ENGINES |
| EVENTS |
| FILES |
| GLOBAL_STATUS |
| GLOBAL_VARIABLES |
| KEY_COLUMN_USAGE |
| PARTITIONS |
| PLUGINS |
| PROCESSLIST |
| PROFILING |
| REFERENTIAL_CONSTRAINTS |
| ROUTINES |
| SCHEMATA |
| SCHEMA_PRIVILEGES |
| SESSION_STATUS |
| SESSION_VARIABLES |
| STATISTICS |
| TABLES |
| TABLE_CONSTRAINTS |
| TABLE_PRIVILEGES |
| TRIGGERS |
| USER_PRIVILEGES |
| VIEWS |
+---------------------------------------+
28 rows in set (0.00 sec)
+---------------------------------------------------------+
| concat("delete from ",table_schema,".",table_name,";") |
+---------------------------------------------------------+
| delete from mysql.columns_priv; |
| delete from mysql.db; |
| delete from mysql.event; |
| delete from mysql.func; |
| delete from mysql.general_log; |
| delete from mysql.help_category; |
| delete from mysql.help_keyword; |
| delete from mysql.help_relation; |
| delete from mysql.help_topic; |
| delete from mysql.host; |
| delete from mysql.ndb_binlog_index; |
| delete from mysql.plugin; |
| delete from mysql.proc; |
| delete from mysql.procs_priv; |
| delete from mysql.servers; |
| delete from mysql.slow_log; |
| delete from mysql.tables_priv; |
| delete from mysql.time_zone; |
| delete from mysql.time_zone_leap_second; |
| delete from mysql.time_zone_name; |
| delete from mysql.time_zone_transition; |
| delete from mysql.time_zone_transition_type; |
| delete from mysql.user; |
+---------------------------------------------------------+
23 rows in set (0.01 sec)
建议继续学习:
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Incessant 来源: Incessant
- 标签: 批量
- 发布时间:2009-10-11 22:32:51
- [25] 招聘技巧一二
- [15] [译]Google Chrome中的高性能网
- [14] 最近总结的一些技巧(vim,python,s
- [14] 关于Linux的文件系统cache
- [14] 在FreeNAS/BSD搭建基于Nginx+
- [12] Linux常用系统信息查看命令
- [11] Linux(Ubuntu 10.04)上安装
- [9] 我对技术方向的一些反思
- [9] Centos yum 安装nginx+PHP
- [8] Redis和Memcached的区别