search

Home  >  Article  >  Database  >  批量删除指定表前缀表

批量删除指定表前缀表

WBOY
WBOYOriginal
2016-06-07 14:57:131763browse

批量删除指定表前缀表 无 源码与演示： 源码出处 Select CONCAT( 'drop table ', table_name, ';' ) FROM information_schema.tables Where table_name LIKE 'dede_%';

批量删除指定表前缀表

源码与演示：源码出处 

Select CONCAT( 'drop table ', table_name, ';' ) 
FROM information_schema.tables 
Where table_name LIKE 'dede_%';
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：获取sql server 指定数据库指定表的基本信息Next article：Sql修改表的主键字段类型以及主键名称从新设置主键

Related articles

See more