清空数据库中的某个表中数据

SELECT
  table_name,
  TABLE_SCHEMA,
  CONCAT(
    'TRUNCATE ',
    TABLE_SCHEMA,
    '.',
    TABLE_NAME,
    ';'
  )
FROM
  information_schema. TABLES
WHERE
  table_schema LIKE '%库%'
AND (
  TABLE_NAME ='table1'
  OR TABLE_NAME ='table2'
);