DV-พื้นฐาน SQL Statement

คำสั่งพื้นฐาน
INSERT INTO <table> (field, field,...) VALUES (data, data,...)
เช่น 
INSERT INTO Emp VALUES (001,"Surapun")
INSERT INTO Emp(name) VALUES ("Surapun")

INSERT INTO <table> SELECT <field, field,...> FROM <table> WHERE <condition>
เช่น 
INSERT INTO faculty 
  SELECT facultyID,facultyName FROM faculty_tab 
  WHERE facultyID NOT IN (SELECT facultyID FROM faculty_test)
INSERT INTO faculty  (facultyName)
  SELECT facultyName FROM faculty_tab 
  WHERE facultyID NOT IN (SELECT facultyID FROM faculty_test)