For an instructor lead, in-depth look at learning SQL click below.
Hello, fellow SQL developers! In today’s post, we will delve deep into the world of SQL, focusing on one of the key elements of SQL data manipulation: the INSERT INTO statement.
What is the INSERT INTO Statement?
The INSERT INTO statement is a crucial part of the SQL data manipulation language (DML). It is primarily used to insert new rows into a database table. Whether you’re dealing with customer information, inventory data, or statistical results, there’s a high chance you’ll need the INSERT INTO statement to get the job done.
INSERT INTO Syntax
|
1 2 3 4 |
INSERT INTO table_name (column1, column2, column3, ....) VALUES (value1, value2, value3, ....); |
In the command above, table_name is the name of the table where you want to insert the data. column1, column2,… are the column names where the data is to be inserted. And value1, value2,… are the new values to be inserted.
Keep in mind that the order of the column names is significant. Your declared values will match up to the columns as they are defined in the table, from left to right.
Example of a Basic INSERT INTO Statement
|
1 2 3 4 5 6 7 8 |
/* Assuming we have a simple table "employees" structured as follows: employees (id INT, first_name VARCHAR(50), last_name VARCHAR(50)) */ INSERT INTO employees (id, first_name, last_name) VALUES (1, 'John', 'Doe'); |
In this example, we’ve added a new row to the “employees” table. Our new employee is called John Doe, and he’s represented in the table by the ID, 1.
Inserting Data Into Selected Columns Only
|
1 2 3 4 5 6 |
/* Assuming the same "employees" table structured */ INSERT INTO employees (first_name, last_name) VALUES ('Jane', 'Doe'); |
In this instance, we only inserted data into the first_name and last_name columns. SQL will assign a NULL value by default in any columns you’ve omitted (like “id” in this case), assuming the omitted columns permit NULL values.
Wrapping Up
The INSERT INTO statement is an essential tool in your SQL toolkit. It permits flexibility when adding data to your database while maintaining data integrity. With practice, you’ll find it’s not as intimidating as it may first appear. It’s all about understanding the structure of your table and what data you wish to include. Happy SQL coding!