小白想問創建數據表這一段代碼是哪里錯了？？？
CREATE?TABLE?t_proj_info( proj_id?INT?AUTO_INCREMENT?PRIMARY?KEY?, canton_id?INT?AUTO_INCREMENT?FOREIGN?KEY, proj_name?VARCHAR(50), proj_no?VARCHAR(5), proj_type?VARCHAR(25), tilth_state?FLOAT, proj_kind?VARCHAR(25), farm_tot?FLOAT, approve_unit?VARCHAR(50) ); 錯誤代碼：?1064You?have?an?error?in?your?SQL?syntax;?check?the?manual?that?corresponds?to?your?MySQL?server?version?for?the?right?syntax?to?use?near?'foreign?key,proj_name?varchar(50),proj_no?varchar(5),proj_type?varchar(25),t'?at?line?3
2019-08-11
外鍵 FOREIGN?KEY?你得關聯一個表里面的列啊?還有AUTO_INCREMENT?自增只能有一列