SQL INSERT INTO 语句用法
发布时间：01/15 来源： 浏览：
关键词：
INSERT INTO 语句用于向表格中插入新的行。
INSERT INTO 表名称 VALUES (值1, 值2,....)
我们也可以指定所要插入数据的列：
INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)
LastName
FirstName
Address
City
Carter
Thomas
Changan Street
Beijing
INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing')
LastName
FirstName
Address
City
Carter
Thomas
Changan Street
Beijing
Gates
Bill
Xuanwumen 10
Beijing
LastName
FirstName
Address
City
Carter
Thomas
Changan Street
Beijing
Gates
Bill
Xuanwumen 10
Beijing
INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs教程-Elysees')
LastName
FirstName
Address
City
Carter
Thomas
Changan Street
Beijing
Gates
Bill
Xuanwumen 10
Beijing
Wilson
Champs-Elysees
