- SQL語法-新增
- 新增一筆資料
- 新增多筆資料
SQL語法-新增
INSERT INTO 資料表
(`欄位1`, `欄位2`, `欄位3`, `欄位4`, `欄位5`,`欄位6`)
VALUES
("值1",值2,值3,值4,"值5","值6")
新增一筆資料
INSERT INTO `grade` (`stu_name`, `stu_english`, `stu_chinese`, `stu_math`, `create_user`,`update_user`,`stu_status`, `stu_del`) VALUES ('Butty', '69', '75', '97', 'SYSTEM','SYSTEM','0', '0');
INSERT INTO grade
(gd_name,gd_english,gd_chinese,gd_math,create_user,update_user)
VALUES
('aaaaa',67,78,55,'SYSTEM','SYSTEM')
新增多筆資料
INSERT INTO grade
(stu_name, stu_english, stu_chinese, stu_math,create_user,update_user)
VALUES
("my4",88,85,91,"system","system"),
("my5",96,70,91,"system","system"),
("my6",77,83,71,"system","system") 
Yiru@Studio - 關於我 - 意如