create table如何建表 create table xxx as select * from bbbb bbbb表數(shù)據(jù)量大,查詢結(jié)果很快,可是創(chuàng)建表報錯00600?
create table xxx as select * from bbbb bbbb表數(shù)據(jù)量大,查詢結(jié)果很快,可是創(chuàng)建表報錯00600?系統(tǒng)錯誤:建議先創(chuàng)建表xxxxx select*frombbb
create table xxx as select * from bbbb bbbb表數(shù)據(jù)量大,查詢結(jié)果很快,可是創(chuàng)建表報錯00600?
系統(tǒng)錯誤:建議先創(chuàng)建表xxxxx select*frombbbwhere1=0,然后插入框XXX select*frombbbbb
create table是Oracle copy table的語法。SQL server相對簡單。直接使用select into即可。int之后的新表不需要預先創(chuàng)建。從表1中選擇*Internet 2,其中