MySQL INSERT Row(s) Statement
MySQL INSERT ROW(s) Statement
The MySQL INSERT
statement is used to add new rows of data into a table. This statement is essential for populating tables with initial data or adding new records to existing tables.
Syntax
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
The INSERT
statement has the following components:
table_name
: The name of the table where the data will be inserted.column1, column2, column3, ...
: The columns in the table where the data will be inserted.value1, value2, value3, ...
: The values to be inserted into the specified columns.
Example MySQL INSERT ROW(s) Statement
Let's look at some examples of the MySQL INSERT
statement:
Step 1: Using the Database
USE mydatabase;
This query sets the context to the database named mydatabase
.

Step 2: Creating a Table
Create a table to work with:
CREATE TABLE employees (
id INT AUTO_INCREMENT PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE
);
This query creates a table named employees
with columns for id
, first_name
, last_name
, and email
.

Step 3: Inserting a Single Row
Insert a single row into the table:
INSERT INTO employees (first_name, last_name, email)
VALUES ('John', 'Doe', 'john.doe@example.com');
This query inserts a new row into the employees
table. The result will be that the employees
table now contains the new row with the specified values.

Step 4: Inserting Multiple Rows
Insert multiple rows into the table:
INSERT INTO employees (first_name, last_name, email)
VALUES ('Jane', 'Smith', 'jane.smith@example.com'),
('Jim', 'Brown', 'jim.brown@example.com');
This query inserts multiple rows into the employees
table. The result will be that the employees
table now contains the new rows with the specified values.

Step 5: Verifying the Inserted Rows
To verify that the rows have been inserted, you can select all rows from the table:
SELECT *
FROM employees;
This query retrieves all rows from the employees
table. The result will show the inserted rows.

Conclusion
The MySQL INSERT
statement is a powerful tool for adding new rows of data into a table. Understanding how to use the INSERT
statement is essential for effective data management and manipulation in MySQL.