INSERT INTO Statement in SQL with Example

We 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)

You May Also Like:

Foreign Key Constraint in SQL Continue Statement Break Statement SELECT Statement in SQL Creating Table & Columns in SQL