use test; begin; create table if not exists t123(id int); insert into t123 values(1); insert into t123 values(2); select * from t123; -- drop table t123; end;
mysql> use test; Database changed mysql> select * from t123; +------+ | id | +------+ | 1 | | 2 | +------+ 2 rows in set (0.00 sec)
第二次啟動以后，得到結果： Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 2 Server version: 5.5.28 MySQL Community Server (GPL) Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. mysql> use test; Database changed mysql> select * from t123; +------+ | id | +------+ | 1 | | 2 | | 1 | | 2 | +------+ 4 rows in set (0.00 sec)
