[SQL]CREATE?TABLE?ORDER?(
SoleId?nvarchar?(50)?NOT?NULL?COMMENT?'訂單編號',
Userid?nvarchar?(50)?NOT?NULL?COMMENT?'客戶編號',
rid?nvarchar?(50)?NOT?NULL?COMMENT?'房間編號',
Soledte?Datetime?(8)?NOT?NULL?COMMENT?'訂單日期',
Number?INT?(4)?NOT?NULL?COMMENT?'數量',
State?nvarchar?(2)?NOT?NULL?COMMENT?'狀態',
Price?smallmoney?(4)?NOT?NULL?COMMIT?'價格'
)
[Err]?1064?-?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?'ORDER?(
SoleId?nvarchar?(50)?NOT?NULL?COMMENT?'訂單編號',
Userid?nvarcha'?at?line?1
3 回答
已采納
vicentia
TA貢獻24條經驗 獲得超28個贊
CREATE TABLE ORDER4 (
? ? SoleId nvarchar (50) NOT NULL COMMENT '訂單編號',
? ? Userid nvarchar (50) NOT NULL COMMENT '客戶編號',
? ? rid nvarchar (50) NOT NULL COMMENT '房間編號',
? ? Soledte Datetime NOT NULL COMMENT '訂單日期',
? ? Number INT (4) NOT NULL COMMENT '數量',
? ? State nvarchar (2) NOT NULL COMMENT '狀態',
? ? money ?double NOT NULL COMMENT '價格'?
)
mysql 沒有 沒有貨幣類型，可用double代替，table名與關鍵字重復
添加回答
舉報
0/150
提交
取消