You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-02 17:22:27 +03:00
25 lines
559 B
Plaintext
25 lines
559 B
Plaintext
DROP DATABASE IF EXISTS mcol4202_db1;
|
|
DROP DATABASE IF EXISTS mcol4202_db2;
|
|
CREATE DATABASE mcol4202_db1;
|
|
CREATE DATABASE mcol4202_db2;
|
|
CREATE TABLE mcol4202_db1.t1 (id INT) ENGINE=Columnstore;
|
|
INSERT INTO mcol4202_db1.t1 values (111);
|
|
RENAME TABLE mcol4202_db1.t1 TO mcol4202_db2.t1;
|
|
SELECT * FROM mcol4202_db2.t1;
|
|
id
|
|
111
|
|
USE mcol4202_db2;
|
|
INSERT INTO t1 values (222);
|
|
SELECT * FROM t1;
|
|
id
|
|
111
|
|
222
|
|
RENAME TABLE mcol4202_db2.t1 to mcol4202_db1.t33333;
|
|
USE mcol4202_db1;
|
|
SELECT * from t33333;
|
|
id
|
|
111
|
|
222
|
|
DROP DATABASE mcol4202_db1;
|
|
DROP DATABASE mcol4202_db2;
|