PettersenKariStorgt 20Stavanger

SQL 语句：

INSERT INTO PersonsVALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')

结果：

PettersenKariStorgt 20StavangerHetlandCamillaHagabakka 24Sandnes

在指定的列中插入数据

"Persons" 表：

PettersenKariStorgt 20StavangerHetlandCamillaHagabakka 24Sandnes

SQL 语句：

INSERT INTO Persons (LastName, Address)VALUES ('Rasmussen', 'Storgt 67')

结果：

PettersenKariStorgt 20StavangerHetlandCamillaHagabakka 24SandnesRasmussen Storgt 67

---

Head photo Go homepage Upload pictures Write articles	SQL初学者教程：掌握学会INSERT INTO 语句_[SQL Server教程] INSERT INTO 语句 INSERT INTO 语句用于向表格中插入新的行。 语法 INSERT INTO table_nameVALUES (value1, value2,....) 我们也可以指定所要插入数据的列： INSERT INTO table_name (column1, column2,...)VALUES (value1, value2,....) 插入新的行 "Persons" 表：	LastName	FirstName	Address	City	LastName	FirstName	Address	City	LastName	FirstName	Address	City	LastName	FirstName	Address	City