INSERT
statement is used to insert new records in a table.
1INSERT INTO table_name (column1, column2, ...)
2VALUES (value1, valu2, ...);
3
4-- make sure the order of the values is in the same order as the columns in the table
5INSERT INTO table_name
6VALUES (value1, valu2, ...);
Sample Database
Id |
FullName |
Title |
Department |
Manager |
1 |
Eric Brown |
Software Engineer |
IT |
Frank Martin |
2 |
Brandon Hart |
DevOps Engineer |
IT |
Justin Martin |
3 |
Connor Langdon |
Software Engineer |
IT |
Lucas Scott |
Examples / Outputs
1-- Id is incremental
2INSERT INTO Engineer (FullName, Title)
3VALUES ('Robert Langdon', 'Frontend Developer')
Id |
FullName |
Title |
Department |
Manager |
1 |
Eric Brown |
Software Engineer |
IT |
Frank Martin |
2 |
Brandon Hart |
DevOps Engineer |
IT |
Justin Martin |
3 |
Connor Langdon |
Software Engineer |
IT |
Lucas Scott |
4 |
Robert Langdon |
Frontend Developer |
|
|
1INSERT INTO Engineer (FullName, Title, Department, Manager)
2VALUES ('Thomas Edison', 'Fullstack Developer', 'Network and Data Science', 'Nikola Tesla')
Id |
FullName |
Title |
Department |
Manager |
1 |
Eric Brown |
Software Engineer |
IT |
Frank Martin |
2 |
Brandon Hart |
DevOps Engineer |
IT |
Justin Martin |
3 |
Connor Langdon |
Software Engineer |
IT |
Lucas Scott |
4 |
Thomas Edison |
Fullstack Developer |
Network and Data Science |
Nikola Tesla |