INSERT INTO Statement in SQL with Example

sqlWe have already created a table in previous tutorial.  Now, we are going to add some records to it.  To add a record in a table, we make use of INSERT INTO statement.  You need to specify values followed by column names.  Gender column contains integer values because in next tutorial, we are going to create another table to establish relationship between 2 tables (Employee and Gender tables).  For now, just follow along.  Syntax for INSERT INTO statement is given below:

INSERT INTO tblEmployee (ID, NAME, Email, Gender)
VALUES (1,'Albert', 'albert@sample.com', 1)
tblEmployee
ID NAME EMAIL GENDER
1 Albert albert@sample.com 1
2 Robert robert@sample.com 1
3 Peter peter@sample.com 1
4 Susan susan@sample.com 2
5 Mary mary@sample.com 3