1,create table vincent_sms as select * from vincent_voice
創建一個表vincent_sms,其字段類型同vincent_voice完全一樣,並會把vincent_voice中的記錄也復制到vincent_sms表中去
注:select子句還可以加where限制條件
===================================================================
2, insert into vincent_sms select * from vincent_voice
將vincent_voice表中的記錄導入vincent_sms 表中
注:select子句還可以加where限制條件,如果vincent_sms 和vincent_voice表結構不一樣的話,當然可以指明字段的。注意,這裡沒有values關鍵字