創建主鍵總是報錯
難道真的只有我創建主鍵的時候會報錯嗎 【/無奈】，已經重新打了好幾次代碼，我確定單詞沒有打錯，很確定和視頻中一樣的，但一運行就是會報
代碼和報錯信息如下：mysql>?CREATE?TABLE?tb3( ????->?id?SMALLINT?UNSIGED?AUTO_INCREMENT?PRIMPAY?KEY, ????->?username?VARCHAR(30)?NOT?NULL ????->?); ERROR?1064?(42000):?You?have?an?error?in?your?SQL?syntax;?check?the?manual?that?corresponds?to?your?MySQL?server?version?for?the?right?syntax?to?use?near?'UNSIGED?AUTO_INCREMENT?PRIMPAY?KEY, username?VARCHAR(30)?NOT?NULL )'?at?line?2
錯【/哭泣】，求大神解答
2017-08-20
mysql>?CREATE?TABLE?tb3(
????->?id?SMALLINT?UNSIGNED?AUTO_INCREMENT?PRIMARY?KEY,
????->?username?VARCHAR(30)?NOT?NULL
????->?);
有兩處錯誤,自己看吧