MySql-語法練習1-新增資料

  • SQL語法-新增
  1. 新增一筆資料
  2. 新增多筆資料

 

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 (stu_name, stu_english, stu_chinese, stu_math, create_user,update_user,stu_status, stu_del) VALUES ('Citty', '69', '75', '97', 'SYSTEM','SYSTEM','0', '0')

新增多筆資料

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")  

YiruAtStudio - 關於我