INSERT INTO

Definition:

To insert record(s) into the table.

---

Command Syntax:

INSERT INTO table_name [(field1_name,field2_name,field3_name...)] VALUES 
('field1_value','field2_value','field3_value'...), #1st record
('field1_value','field2_value','field3_value'...), #2nd record
('field1_value','field2_value','field3_value'...), #3rd record...
('field1_value','field2_value','field3_value'...); #Nth record

• insert new record(s) into existing table called table_name with specific/exact field(s)
• the order of field value in the inserting record(s) should be as same as specific/exact field(s)

---

'Don't mixed up the order.'By secondary 6 student