mysql数据库进行清洗,清理数据库

Mysql

查询所有数据库

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| ttbb |

+--------------------+

5 rows in set (0.01 sec)

进入数据库一个一个清理

mysql> use ttbb

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

产生删除表的sql语句

mysql> select concat("DROP TABLE IF EXISTS ", table_name, ";") from information_schema.tables where table_schema="ttbb";

+--------------------------------------------------+

| concat("DROP TABLE IF EXISTS ", table_name, ";") |

+--------------------------------------------------+

| DROP TABLE IF EXISTS old_table_etl_scene_2; |

+--------------------------------------------------+

1 row in set (0.00 sec)

注意table_schema要替换成您的数据库名称

复制执行语句即可

mysql> DROP TABLE IF EXISTS old_table_etl_scene_2;

Query OK, 0 rows affected (0.03 sec)

Mongo

查询所有数据库

> show databases;

admin 0.000GB

config 0.000GB

local 0.000GB

test 0.000GB

ttbb 0.000GB

进入数据库

> use ttbb

switched to db ttbb

清理数据库

> db.dropDatabase();

{ "dropped" : "ttbb", "ok" : 1 }

> show databases;

admin 0.000GB

config 0.000GB

local 0.000GB

test 0.000GB