INSERT..() VALUE..() INSERT SCORE (SID, COURSE, SCORE) VALUES ('S001', '程式設計', 86) INSERT SCORE (SID, COURSE, SCORE) VALUES ('A003', '程式設計', 74) 由於各欄位不可為NULL,故語法可以省略為下: INSERT SCORE VALUE ('S002', '演算法', 77) INSERT SCORE VALUE ('S003', '演算法', 57) =============== UPDATE.. SET..= WHERE..= UPDATE SCORE SET COURSE = '物件導向程式設計', SCORE = 95 WHERE SID = 'S001' ================= DELETE FROM.. WHERE..= DELETE FROM SCORE WHERE SID = 'S003' ================= SELECT * FROM SCORE SELECT SID AS '學號', COURSE AS '科目名稱', SCORE AS '分數" FROM SCORE
[تدريب]ASP.NET MVC 5 - لغة معالجة بيانات DML 1
اترك التعليق