- 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) VALUES ('a6',60,70,51,'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 - 關於我 - 意如