多表更新的小問題
“多表更新一步到位”那一節有一個要注意的地方,大家可以嘗試這樣改一下:?
CREATE?TABLE?tdb_goods_brands( ???brands_id?SMALLINT?UNSIGNED?PRIMARY?KEY?AUTO_INCREMENT, ???brands_name?VARCHAR(40)?NOT?NULL?)? ???SELECT?brand_name?FROM?tdb_goods?GROUP?BY?brand_name;? )
“多表更新一步到位”那一節有一個要注意的地方,大家可以嘗試這樣改一下:?
CREATE?TABLE?tdb_goods_brands( ???brands_id?SMALLINT?UNSIGNED?PRIMARY?KEY?AUTO_INCREMENT, ???brands_name?VARCHAR(40)?NOT?NULL?)? ???SELECT?brand_name?FROM?tdb_goods?GROUP?BY?brand_name;? )
2016-03-27
舉報
2016-03-27
最后那個括號是干什么用的,請仔細查看