Insert Query in Mysql

An INSERT query in MySQL is used to add new records or rows into a table. It allows you to specify the values that should be inserted into the respective columns of the table. Let's discuss the details of an INSERT query in MySQL:

Syntax: 
                
    INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
Explanation of the syntax elements:

* INSERT INTO: This keyword is used to indicate that you want to insert data into a table.

* table_name: This is the name of the table into which you want to insert the data.

* column1, column2, ...: These are the names of the columns in the table where you want to insert values. You can specify multiple columns separated by commas.

* VALUES: This keyword is used to specify the values that should be inserted into the corresponding columns. The values should be provided in the same order as the columns.

* value1, value2, ...: These are the values that you want to insert into the respective columns. You should provide values in the same order as the columns mentioned.

Example:

Let's assume we have a table called "customers" with columns "customer_id", "first_name", "last_name", and "email". Here's an example of an INSERT query:

Syntax: 
                
    INSERT INTO customers (customer_id, first_name, last_name, email) VALUES (1, 'John', 'Doe', 'john@example.com');

This query inserts a new record into the "customers" table with the specified values. The values provided correspond to the columns "customer_id", "first_name", "last_name", and "email".

You can also insert multiple rows at once by providing multiple sets of values within the same INSERT query. Here's an example:

Syntax: 
                
    INSERT INTO customers (customer_id, first_name, last_name, email)
    VALUES (2, 'Jane', 'Smith', 'jane@example.com'),
    (3, 'Mark', 'Johnson', 'mark@example.com'),
    (4, 'Emily', 'Davis', 'emily@example.com');

This query inserts three new records into the "customers" table in a single query.

Remember to adjust the table name, column names, and values based on your specific scenario. Ensure that the values match the data types of the corresponding columns in the table.

Next Post