MySQL INSERT INTO Statement

MySQL INSERT INTO Statement

The INSERT INTO statement in MySQL is used to add new records (rows) to a table. It is one of the most commonly used SQL commands for storing data in a database.

📌 Basic Syntax

There are two ways to use the INSERT INTO statement:

 1. Insert values into all columns

✔ Use this only when you provide values for every column in the correct order.

 2. Insert values into specific columns

✔ This method is preferred because it is flexible and avoids errors.

🧪 Example Table

Assume a table named students:

🏷 Example 1: Insert All Column Values

🏷 Example 2: Insert into Selected Columns

If the id column is AUTO_INCREMENT, MySQL will automatically assign it.

📌 Insert Multiple Rows in One Query

✔ This method is faster than running separate insert statements.

🔠 Insert with NULL Value

If a column allows NULL, you can insert null like:

🔧 Insert with Default Values

If a table has default values:

Here, age will take its default or null value.

🎯 Example with AUTO_INCREMENT

Table structure:

Insert:

🟢 MySQL automatically assigns the next available id.

🧠 Best Practices

✔ Always specify column names
✔ Use proper data types
✔ Use multiple row insert for performance

🏁 Summary

✔ The INSERT INTO statement is essential for adding new data to a MySQL table.