资料来源: GoalKicker.com SQL Notes
我在课堂讲稿中发现了很多多余的问题。比如在声明id列之后手动插入id值,以在DDL中自动递增。难到不是么?
DDL:
CREATE TABLE Books
(
Id INT NOT NULL AUTO_INCREMENT,
Title VARCHAR(50) NOT NULL,
PRIMARY KEY(Id)
);
DML:
INSERT INTO Books (Id, Title)
VALUES
(1, 'The Catcher in the Rye'),
(2, 'Nine St