Vue

MySql INSERT INTO

INSERT INTO 語法 (SQL INSERT INTO Syntax)

1
2
3
4
5
INSERT INTO table_name (column1, column2, column3...)
VALUES (value1, value2, value3...);
//or
INSERT INTO table_name
VALUES (value1, value2, value3...);
INSERT INTO例子
1
2
3
4
5
6
INSERT INTO customers (C_Id, Name, City, Address, Phone)
VALUES (3, '李三', '高雄縣', 'ZZ路300號', '07-12345678');
or
INSERT INTO customers
VALUES (3, '李三', '高雄縣', 'ZZ路300號', '07-12345678');