check_eme_columns.sql 462 B

1234567
  1. -- 搜索应急相关表 + 用户指定的表
  2. SELECT table_name FROM information_schema.tables
  3. WHERE table_schema = 'slaj'
  4. AND (table_name LIKE 't_busi%' OR table_name LIKE '%eme%' OR table_name LIKE '%emgc%' OR table_name LIKE '%emerge%'
  5. OR table_name LIKE '%drill%' OR table_name LIKE '%conplan%' OR table_name LIKE '%supplies%'
  6. OR table_name LIKE '%team_info%' OR table_name LIKE '%train_record%' OR table_name LIKE '%insure%')
  7. ORDER BY table_name;