1. 课本给的表分析
2. 在执行表2.3.4(订单表)的创建时
- 原sql语句
-- 创建订单表
CREATE TABLE Orders(
OrderID INT NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT'订单ID',
ReceiptsCode VARCHAR(14) NOT NULL COMMENT'流水号',
CONSTRAINT uk_index1 UNIQUE KEY(ReceiptsCode),
OrdersDate DATE NOT NULL DEFAULT SELECT CURRENT_DATE() COMMENT'订单日期',
Amount DECIMAL(8,2) COMMENT'用户ID',
UserID INT COMMENT'用户ID',
CONSTRAINT fk_Orders_User FOREIGN KEY(UserID) REFERENCES `user`(UserID)
)
- 报错语句
> 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 'SELECT CURRENT_DATE() COMMENT'订单日期',
Amount DECIMAL(8,2) COMMENT'用' at line 5
> 时间: 0s