SQL 根據已有的表創建新表

SQL 根據已有的表創建新表

SQL 根據已有的表創建新表


資料來源: https://mp.weixin.qq.com/s?__biz=MzU2MTgxNTE1Nw==&mid=2247484945&idx=2&sn=0106ad3710089d88d739ba366c97c108&chksm=fc724d0bcb05c41d012f181707dae735265e755a61850b4ff42ed95059b0f5fb1cccd01a861e&scene=0&xtrack=1&key=1740f1858e7c6828fcc557c0fc5e2a1f954e82e78b620527fcd25d2a7569b86926dddb965e3b2a29e2706489b578528aa5f88c477aea4181ee41e84f53351b20fb5f84a8e7ec0889afc110dfca6f34b1&ascene=1&uin=MjIwODk2NDgxNw%3D%3D&devicetype=Windows+10&version=62070158&lang=zh_TW&exportkey=Aq3IIPu1NkOF1MBZrKVkzno%3D&pass_ticket=ZUUa3mN%2B4mSNtukzuvnB62y7KFi%2Fru6bIHP6SgFbYiNf0Jc7mnfx22p71VAfeL5m


A:create table tab_new like tab_old (使用舊表創建新表)

B :create table tab_new as select col1,col2… from tab_old definition only















發表迴響

你的電子郵件位址並不會被公開。 必要欄位標記為 *