mysql查询所有表

 查询所有表某 like字段

$sql = "SELECT table_name FROM information_schema. COLUMNS WHERE table_name LIKE '%fa_app_%' GROUP BY table_name;";
 
$res = Db::query( $sql );

清空表名称  bi_开头 

SELECT CONCAT('delete from',table_name,';') FROM information_schema.columns where table_name like 'bi\_%' group by table_name;

 

select CONCAT('truncate TABLE ',table_schema,'.',TABLE_NAME, ';') from INFORMATION_SCHEMA.TABLES where  table_schema in ('dd');

tp5查询所有like过滤表，并清空表

//查询数据库所有表,过滤部分表,并删除表的所有内容
        $arr = [
            0 => "fa_app_jade_mall",
            1 => "fa_app_package",
            2 => "fa_app_usdt",
        ];
        $sql = "SELECT table_name FROM information_schema. COLUMNS WHERE table_name LIKE '%fa_app%' GROUP BY table_name;";
        $all_table = Db::query( $sql );
        if($all_table){
            foreach( $all_table as $key => $value ){
                if(in_array( $value['table_name'] , $arr )){
                    $sql1 = "truncate  ".$value['table_name'];
                    Db::query( $sql1 );
                }
            }
        }