MySQL小技巧
批量删库
例如批量删除th开头的数据库,可以直接导出SQL,复制粘贴
SELECT CONCAT( 'drop database ','`',SCHEMA_NAME,'`',';' ) FROM information_schema.SCHEMATA WHERE SCHEMA_NAME LIKE 'th%';
批量删表
例如批量删除mydb库中所有mytb_开头的表,可以直接导出SQL,复制粘贴
SELECT CONCAT( 'drop table ','`',table_schema,'`','.' , '`',table_name,'`', ';' ) FROM information_schema.tables WHERE table_schema='mydb' AND table_name LIKE 'mytb_%' ;
查看所有权限
SELECT DISTINCT CONCAT('show grants for ''',user,'''@''',host,''';') AS query FROM mysql.user;