create table mdmuser20120801 as select * from mdmuser
方法 2:
create table mdmuser20120801 as select * from mdmuser where 1=2;insertinto mdmuser20120801select * from mdmuser ;
来源: http://www.bubuko.com/infodetail-2616475.html