惠祎說(shuō)除了生死都是小事丶
2017-03-28 14:52:15
mysql> CREATE TABLE tb1(? ? -> username VARCHAR(20),? ? -> salary FLOAT(8,2) UNSIGNED,? ? -> );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 ',2) UNSIGNED,)' at line 3這是什么情況
4 回答

堯叔
TA貢獻(xiàn)77條經(jīng)驗(yàn) 獲得超201個(gè)贊
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 ',2) UNSIGNED,
)' at line 3
耐心點(diǎn)看,意思你第三行的2附近有語(yǔ)法錯(cuò)誤,我目測(cè)是個(gè)中文逗號(hào)。
謝謝采納~

慕妹5461943
TA貢獻(xiàn)290條經(jīng)驗(yàn) 獲得超0個(gè)贊
添加回答
舉報(bào)
0/150
提交
取消