TiDB select into from替代方案
适用场景:批量更新数据前全表备份等
实现代码:
//sqlserver
select into table_name_new from table_name
//oracle
create table table_name_new as select * from table_name;
//tidb(mysql应该也适用)
create table table_name_new like table_name;
insert into table_name_new
select * from t
原创
2020-08-20 11:16:00 ·
1753 阅读 ·
0 评论