Insert Statement
This command allows data to be inserted, one row at a time, into an existing table
Syntax: Insert into <tablename> (list of attributes) values (list of values)
Note: The list of attributes can be ignored providing the order of attribute values, and completeness of attribute instances, is as per the table list.
example: insert into emp(name, sal, byear)
values(‘Jones, Bill’, 45000,1967);
or(see note) insert into emp values(‘Jones, Bill’, 45000,1967);