/*[12:48:11][ 94 ms]*/ SHOW VARIABLES LIKE 'lower_case_table_names'; /*[12:48:11][ 16 ms]*/ SET NAMES 'utf8'; /*[12:48:11][ 0 ms]*/ SET sql_mode=''; /*[12:48:11][ 93 ms]*/ SHOW DATABASES; /*[12:48:13][ 0 ms]*/ USE `test`; /*[12:48:15][ 422 ms]*/ SHOW TABLE STATUS FROM `test`WHERE ENGINE IS NOT NULL; /*[12:48:15][ 31 ms]*/ SELECT `TABLE_NAME` AS View_name,`View_definition`,`Check_option`,`Is_updatable`,`Definer`,`Security_type` FROM `INFORMATION_SCHEMA`.`VIEWS` WHERE `TABLE_SCHEMA` = 'test'; /*[12:48:15][ 0 ms]*/ SHOW PROCEDURE STATUS WHERE Db = 'test'; /*[12:48:15][ 0 ms]*/ SHOW FUNCTION STATUS WHERE Db='test'; /*[12:48:15][ 16 ms]*/ SHOW TRIGGERS FROM `test`; /*[12:48:15][ 0 ms]*/ SELECT `Event_name`,`Definer`,`Event_type`,`Execute_at`,`Interval_value`,`Interval_field`,`Starts`,`Ends`,`Status` FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE `EVENT_SCHEMA` = 'test'; /*[12:48:15][ 0 ms]*/ SHOW CREATE DATABASE `test`; 你的意思是这些信息的快照吗
/*[12:48:11][ 16 ms]*/ SET NAMES 'utf8';
/*[12:48:11][ 0 ms]*/ SET sql_mode='';
/*[12:48:11][ 93 ms]*/ SHOW DATABASES;
/*[12:48:13][ 0 ms]*/ USE `test`;
/*[12:48:15][ 422 ms]*/ SHOW TABLE STATUS FROM `test`WHERE ENGINE IS NOT NULL;
/*[12:48:15][ 31 ms]*/ SELECT `TABLE_NAME` AS View_name,`View_definition`,`Check_option`,`Is_updatable`,`Definer`,`Security_type` FROM `INFORMATION_SCHEMA`.`VIEWS` WHERE `TABLE_SCHEMA` = 'test';
/*[12:48:15][ 0 ms]*/ SHOW PROCEDURE STATUS WHERE Db = 'test';
/*[12:48:15][ 0 ms]*/ SHOW FUNCTION STATUS WHERE Db='test';
/*[12:48:15][ 16 ms]*/ SHOW TRIGGERS FROM `test`;
/*[12:48:15][ 0 ms]*/ SELECT `Event_name`,`Definer`,`Event_type`,`Execute_at`,`Interval_value`,`Interval_field`,`Starts`,`Ends`,`Status` FROM `INFORMATION_SCHEMA`.`EVENTS` WHERE `EVENT_SCHEMA` = 'test';
/*[12:48:15][ 0 ms]*/ SHOW CREATE DATABASE `test`;
你的意思是这些信息的快照吗
所以你不用担心你的问题.