IIabm/SQL_migrate_db.sql

13 lines
804 B
MySQL
Raw Permalink Normal View History

2023-09-03 22:15:17 +08:00
CREATE DATABASE iiabmdb20230821;
RENAME TABLE iiabmdb.not_test_experiment TO iiabmdb20230821.not_test_experiment,
iiabmdb.not_test_result TO iiabmdb20230821.not_test_result,
iiabmdb.not_test_sample TO iiabmdb20230821.not_test_sample,
iiabmdb.test_experiment TO iiabmdb20230821.test_experiment,
iiabmdb.test_result TO iiabmdb20230821.test_result,
iiabmdb.test_sample TO iiabmdb20230821.test_sample;
RENAME TABLE iiabmdb.with_exp_experiment TO iiabmdb20230821.with_exp_experiment,
iiabmdb.with_exp_result TO iiabmdb20230821.with_exp_result,
iiabmdb.with_exp_sample TO iiabmdb20230821.with_exp_sample,
iiabmdb.without_exp_experiment TO iiabmdb20230821.without_exp_experiment,
iiabmdb.without_exp_result TO iiabmdb20230821.without_exp_result,
iiabmdb.without_exp_sample TO iiabmdb20230821.without_exp_sample;