alter table byp3 rename to byp_2
rename byp_2 to byp3
create byp_2 as
select * from byp3
(在这里还可以给加个where限制条件直接取一个表格式或者取一部分数据就行)
drop byp3
本文共 181 字,大约阅读时间需要 1 分钟。
alter table byp3 rename to byp_2
rename byp_2 to byp3
create byp_2 as
select * from byp3
(在这里还可以给加个where限制条件直接取一个表格式或者取一部分数据就行)
drop byp3
转载于:https://blog.51cto.com/11504741/1770653