31 lines
983 B
Plaintext
31 lines
983 B
Plaintext
# ==== Purpose ====
|
|
#
|
|
# CREATE/DROP TEMPORARY TABLE in different ways.
|
|
#
|
|
# ==== Implementation ====
|
|
#
|
|
# 1. CREATE/DROP TEMPORARY TABLE with SELECT.
|
|
# 2. CREATE/DROP TEMPORARY TABLE directly.
|
|
# 3. CREATE/DROP TEMPORARY TABLE with LIKE.
|
|
#
|
|
# ==== References ====
|
|
#
|
|
# Wl#8872 Allow CREATE TEMPORARY/DROP TEMPORARY in transaction when GTID_MODE=ON in RBR
|
|
|
|
CREATE TEMPORARY TABLE tmp1 ENGINE=InnoDB SELECT * FROM t1;
|
|
DROP TEMPORARY TABLE tmp1;
|
|
CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2;
|
|
DROP TEMPORARY TABLE tmp2;
|
|
CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1;
|
|
DROP TEMPORARY TABLE tmp3;
|
|
CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2;
|
|
DROP TEMPORARY TABLE tmp4;
|
|
CREATE TEMPORARY TABLE tmp5 (a INT) ENGINE=InnoDB;
|
|
DROP TEMPORARY TABLE tmp5;
|
|
CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM;
|
|
DROP TEMPORARY TABLE tmp6;
|
|
CREATE TEMPORARY TABLE tmp7 LIKE t1;
|
|
DROP TEMPORARY TABLE tmp7;
|
|
CREATE TEMPORARY TABLE tmp8 LIKE t2;
|
|
DROP TEMPORARY TABLE tmp8;
|