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
- [755] WEB系统需要关注的一些点
- [128] 如何拿下简短的域名
- [22] 移动音乐产品梳理
- [16] 豆瓣是啥?
- [14] 内存的惰性初始化
- [14] Chrome开发者工具的小技巧
- [12] 产品经理的取舍之道与抽象能力
- [12] 基于SSD的数据库性能优化
- [11] 为什么工程师会造出蹩脚的产品
- [11] iOS和Android设计规范备忘表