How to insert data in MySQL table - MySQL Tutorial

in this tutorial, you will learn how to insert data in MySQL table

Syntax:

INSERT INTO table_name ( field1, field2,...fieldN )
   VALUES
   ( value1, value2,...valueN );

Example

we have test table, now we are insert data to it.

+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| id    | int(11)      | NO   | PRI | NULL    | auto_increment |
| title | varchar(100) | NO   |     | NULL    |                |
+-------+--------------+------+-----+---------+----------------+

Insert query:

mysql > INSERT INTO test
              (title) VALUES('test ttile');

Insert multiple data

you can insert multiple data at once.

mysql > INSERT INTO test
              (title) VALUES
              ('test title'),
              ('test title2'),
              ('test title3');,

this will help you to insert data in MySQL table.