INSERT INTO

insert into 语句用于向表格中插入新的行。 语法

INSERT INTO 表名称 VALUES (值1,值2,.....)

我们也可以指定所要插入的数据列:

INSERT INTO TABLE_NAME(NAME1,NAME2,NAME3,....) VALUES (VALUE1,VALUE2,VALUE3,....)

---

插入新的行

INSERT INTO CAR (VIN,BRAND,MODEL,PRICE,PRODUCTION_YEAR) VALUES ('LP859CCSRH5555963','Toyota','Avensis',12000.00,'2009')

结果:

VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsanull2007LP859CCSRH5555963ToyotaAvensis12000.002009

---

在指定的列中插入数据 INSERT INTO CAR (VIN,BRAND ,PRICE) VALUES ('LP859CCSRH5555962','Toyota',12000.00);

结果:

VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsanull2007LP859CCSRH5555963ToyotaAvensis12000.002009LP859CCSRH5555962Toyota12000.00

---