|
Syntax CREATE OR REPLACE TABLE foo LIKE bar is accepted, but it does actually not replace the table. If table `foo` already exists, it causes ER_TABLE_EXISTS_ERROR:
MariaDB [test]> drop table if exists t1, t2;
|
Query OK, 0 rows affected (0.35 sec)
|
|
MariaDB [test]> create table t1 (i int);
|
Query OK, 0 rows affected (1.61 sec)
|
|
MariaDB [test]> create table t2 like t1;
|
Query OK, 0 rows affected (1.67 sec)
|
|
MariaDB [test]> create or replace table t2 like t1;
|
ERROR 1050 (42S01): Table 't2' already exists
|
revision-id: monty@askmonty.org-20140110153917-3r8owmbgslg2552n
|
revno: 3965
|
branch-nick: mariadb-monty
|
|
[MDEV-5519]