先写一个函数(创建存储过程) CREATE PROCEDURE insert_monitor () BEGIN SET @V_EXEC_SQL = concat( "CREATE TABLE matchs_", DATE_FORMAT( now(), '%Y%m' ), " AS SELECT * FROM matchs;" ); PREPAR