How to Insert Data into Table

The INSERT INTO statement is used to insert new records in a table.

images/articles/mysql/insert-data-in-table.jpg

To insert in specified columns,

INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3);

If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query. However, make sure the order of the values is in the same order as the columns in the table.

INSERT INTO table_name VALUES (value1, value2, value3);

There are single quotes enclosing the values in the INSERT statement for the the values that are of the CHAR type. On the other hand, INTEGER data is not enclosed in single quotes.

In a more realistic situation, instead of entering an INSERT statement into SQL, the data entry person would enter data values into fields on a form. The values would be captured into variables, which would then be used to populate the VALUES clause of an INSERT statement.