Inserting Data in MySQL Tables

There is no importance to any table as long as there is no data in it. Once you have created the table, you can begin to store data in it. There are several ways to store data in any database table. In this blog, you will be asked to store data with the INSERT statement.


The INSERT statement with the VALUES clause is used to add new rows to the tables. In such statements, you define values ​​directly. You can also define the column names, but this is optional.

Any row is written in values ​​order and is separated from the comma (,). Also, you should also keep in mind that all string values ​​are defined in single quotes. The basic syntax of this kind of statement is given below.

mysql> INSERT INTO table_name (Column1, Column2, Column3) VALUES (Value1, Value2, Value3);