1
by brian
clean slate |
1 |
drop table if exists t1, t2;
|
2 |
CREATE TABLE t1 ( a int );
|
|
3 |
INSERT INTO t1 VALUES (1),(2),(1);
|
|
4 |
CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
|
|
5 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
6 |
select * from t2;
|
|
7 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
8 |
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=INNODB SELECT a FROM t1;
|
|
9 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
10 |
select * from t2;
|
|
11 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
12 |
CREATE TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
|
|
13 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
14 |
select * from t2;
|
|
15 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
16 |
CREATE TEMPORARY TABLE t2 ( PRIMARY KEY (a) ) ENGINE=MYISAM SELECT a FROM t1;
|
|
17 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
18 |
select * from t2;
|
|
19 |
ERROR 42S02: Table 'test.t2' doesn't exist
|
|
20 |
drop table t1;
|