創(chuàng)建主鍵總是報(bào)錯(cuò)
難道真的只有我創(chuàng)建主鍵的時(shí)候會(huì)報(bào)錯(cuò)嗎 【/無(wú)奈】，已經(jīng)重新打了好幾次代碼，我確定單詞沒(méi)有打錯(cuò)，很確定和視頻中一樣的，但一運(yùn)行就是會(huì)報(bào)
代碼和報(bào)錯(cuò)信息如下：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
錯(cuò)【/哭泣】，求大神解答
2017-08-20
mysql>?CREATE?TABLE?tb3(
????->?id?SMALLINT?UNSIGNED?AUTO_INCREMENT?PRIMARY?KEY,
????->?username?VARCHAR(30)?NOT?NULL
????->?);
有兩處錯(cuò)誤,自己看吧