萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> mysql教程 >> SQL INSERT INTO 語句用法

SQL INSERT INTO 語句用法


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


copyright © 萬盛學電腦網 all rights reserved