Client Area

MySQL Command: INSERT()

MySQL Command: INSERT()

MySQL is a popular open-source relational database management system that allows users to store, manage, and retrieve data efficiently. One of the most commonly used commands in MySQL is INSERT(). In this article, we will explore the INSERT() command and its various functionalities.

What is the INSERT() command?

The INSERT() command in MySQL is used to insert new rows of data into a table. It allows users to specify the values for each column in the table, effectively adding new records to the database. The basic syntax of the INSERT() command is as follows:

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

Here, table_name refers to the name of the table where the data will be inserted. column1, column2, column3, ... represents the columns in the table, and value1, value2, value3, ... represents the corresponding values for each column.

Examples of using the INSERT() command

Let’s consider a hypothetical scenario where we have a table named “customers” with columns such as “id,” “name,” and “email.” We can use the INSERT() command to add new customers to this table.

INSERT INTO customers (id, name, email)
VALUES (1, 'John Doe', 'john@example.com');

In this example, we are inserting a new customer with an ID of 1, name “John Doe,” and email “john@example.com” into the “customers” table.

We can also insert multiple rows of data using a single INSERT() command. For instance:

INSERT INTO customers (id, name, email)
VALUES (2, 'Jane Smith', 'jane@example.com'),
       (3, 'Mike Johnson', 'mike@example.com'),
       (4, 'Sarah Williams', 'sarah@example.com');

In this case, we are inserting three new customers into the “customers” table with their respective IDs, names, and emails.

Additional functionalities of the INSERT() command

The INSERT() command offers additional functionalities to enhance data insertion:

INSERT INTO SELECT

The INSERT INTO SELECT statement allows users to insert data into a table from another table or a query result. This is useful when we want to copy data from one table to another or filter and transform data before inserting it into a table.

INSERT INTO table_name (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM another_table
WHERE condition;

INSERT IGNORE

The INSERT IGNORE statement allows users to insert data into a table while ignoring any duplicate key errors. If a duplicate key error occurs, the INSERT IGNORE statement will skip the duplicate rows and continue inserting the remaining rows.

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

INSERT ON DUPLICATE KEY UPDATE

The INSERT ON DUPLICATE KEY UPDATE statement allows users to insert data into a table. If a duplicate key error occurs, instead of skipping the row, it updates the existing row with the new values.

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...)
ON DUPLICATE KEY UPDATE column1 = value1, column2 = value2, column3 = value3;

Summary

The INSERT() command in MySQL is a powerful tool for inserting new rows of data into a table. It allows users to specify the values for each column and supports various functionalities such as INSERT INTO SELECT, INSERT IGNORE, and INSERT ON DUPLICATE KEY UPDATE. By leveraging the INSERT() command, users can efficiently manage and manipulate data in their MySQL databases.

For more information about VPS hosting services, visit Server.HK.