{"id":176446,"date":"2026-02-19T00:25:22","date_gmt":"2026-02-18T23:25:22","guid":{"rendered":"https:\/\/liora.io\/en\/?p=176446"},"modified":"2026-02-19T00:25:23","modified_gmt":"2026-02-18T23:25:23","slug":"insert-into-sql-insert-data-with-this-sql-query","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/insert-into-sql-insert-data-with-this-sql-query","title":{"rendered":"INSERT INTO SQL: Insert data with this SQL query"},"content":{"rendered":"

To insert data into your SQL table, you can use the INSERT INTOSQL query. But how does it work? That’s what we’re going to look at in this article.<\/strong><\/p>\t\t\n\t\t\t

What is an INSERT INTO SQL request?<\/h2>\t\t\n\t\t

INSERT INTO SQL<\/strong> is one of the most commonly used commands in the SQL language<\/a>. And with good reason: this query allows you to integrate new records into your database. This can be one or more rows, depending on your needs.<\/p>

Good to know: INSERT INTO SQL<\/strong> is the command to use for all database management<\/a> systems. Whether you’re using Oracle<\/a>, Mysql, Transact-SQL, etc.<\/p>\t\t\n\t\t\t

How do I use the SQL query INSERT INTO?<\/h2>
\"A<\/figure>\t\t\n\t\t

INSERT INTO SQL<\/strong> can be used to insert one or more rows into your table. But it’s also possible to use this command in more complex queries. In this article, we’ll take a look at some of these applications.<\/p>\t\t\n\t\t\t

Insert a line<\/h3>\t\t\n\t\t

There are two ways of doing this.<\/p>

1\u00ba<\/strong> You can insert a line by specifying all the columns. In this case, the syntax is as follows:<\/p>

INSERT INTO table VALUES (‘value 1’, ‘value 2’, …)<\/p>

If you choose this option, be sure to respect the order of the columns. The database management system interprets SQL queries according to the information you give it. So if you don’t need to record new values for certain columns, you’ll need to specify “NULL” (instead of value 1,2…).<\/p>

The advantage is that you don’t need to write the name of each limit. This greatly reduces typing errors.<\/p>

2\u00ba<\/strong> You can specify only those columns for which you wish to integrate new data. To do this, use the following syntax:<\/p>

INSERT INTO table (column-name_1, column-name_2, …)
VALUES (‘value 1’, ‘value 2’, …)<\/p>

Here, column order is no longer as important. Be careful, however, with the order of values. They must correspond to the columns to which they are assigned.<\/p>\t\t\n\t\t\t

Insert several lines<\/h3>\t\t\n\t\t

It is often necessary to insert several lines to enrich your table.<\/p>

To help you understand, here’s a concrete example of a Customer file to which you want to add the contact details of several customers.<\/p>

Here’s the query:<\/p>

INSERT INTO customer (first name, last name, city, email)
VALUES
(‘Justine’, ‘Martin’, ‘Paris’, ‘justinemartin@gmail.com’ ),
(‘Thomas’, ‘Durant’, ‘Bordeaux’, ‘tomtom@sfr.fr’),
(‘Marie’, ‘Leroy’, ‘Angers’, ‘marieleroy@laposte.net’),
(‘Vanessa’, ‘Savary’, ‘Marseille’, ‘vanessa13@gmail.com’)<\/p>\t\t\n\t\t\t\n

Learn how to use INSERT INTO<\/a><\/div><\/div>\n\n\t\t

Use the INSERT INTO command to integrate the following data into your table.<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n\n\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n
First Name<\/th>\n Last Name<\/th>\n City<\/th>\n Email<\/th>\n <\/tr>\n<\/thead>\n
Justin<\/td>\n Martin<\/td>\n Paris<\/td>\n justinemartin@gmail.com<\/td>\n <\/tr>\n
Thomas <\/td>\n Durant<\/td>\n Bordeaux<\/td>\n tomtom@sfr.fr<\/td>\n <\/tr>\n
Marie<\/td>\n Leroy<\/td>\n Angers<\/td>\n marieleroy@laposte.net<\/td>\n <\/tr>\n
Vanessa<\/td>\n Savary<\/td>\n Marseille<\/td>\n vanessa13@gmail.com<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t\t

Copy data from another table<\/h3>\t\t\n\t\t

By combining several queries, you can also copy data from an A array to a table.<\/p>

To do this, use the following syntax:<\/p>

INSERT INTO my_table_1 SELECT column_1,column_2,column_2 FROM my_table_2 WHERE conditions<\/p>

Let’s take an example:<\/p>

You have two tables. The first corresponds to a “customer” file:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n\n\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n
Pr\u00e9nom<\/th>\n Nom<\/th>\n Ville<\/th>\n Email<\/th>\n <\/tr>\n<\/thead>\n
Justin<\/td>\n Martin<\/td>\n Paris<\/td>\n justinemartin@gmail.com<\/td>\n <\/tr>\n
Thomas <\/td>\n Durant<\/td>\n Bordeaux<\/td>\n tomtom@sfr.fr<\/td>\n <\/tr>\n
Marie<\/td>\n Leroy<\/td>\n Angers<\/td>\n marieleroy@laposte.net<\/td>\n <\/tr>\n
Vanessa<\/td>\n Savary<\/td>\n Marseille<\/td>\n vanessa13@gmail.com<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\t\t\n\t\t

And the second, to a “Prospecting” file:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n\n\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n
First Name<\/th>\n Last Name<\/th>\n City<\/th>\n Email<\/th>\n <\/tr>\n<\/thead>\n
Justin<\/td>\n Martin<\/td>\n Paris<\/td>\n justinemartin@gmail.com<\/td>\n <\/tr>\n
Thomas <\/td>\n Durant<\/td>\n Bordeaux<\/td>\n tomtom@sfr.fr<\/td>\n <\/tr>\n
Marie<\/td>\n Leroy<\/td>\n Angers<\/td>\n marieleroy@laposte.net<\/td>\n <\/tr>\n
Vanessa<\/td>\n Savary<\/td>\n Marseille<\/td>\n vanessa13@gmail.com<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t

Having converted a prospect (Jean Bernard), you want to transfer him to your customer file.<\/p>

Here’s the query:<\/p>

INSERT INTO Customer SELECT (first name, last name, city, email) FROM prospect WHERE id = 1<\/p>

And the result:<\/p>\t\t\n\t\t\t\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n\n\n\n\n\n\n\n<\/colgroup>\n\n \n \n \n \n \n \n \n
First Name<\/th>\n Last Name<\/th>\n City<\/th>\n Email<\/th>\n <\/tr>\n<\/thead>\n
Justin<\/td>\n Martin<\/td>\n Paris<\/td>\n justinemartin@gmail.com<\/td>\n <\/tr>\n
Thomas <\/td>\n Durant<\/td>\n Bordeaux<\/td>\n tomtom@sfr.fr<\/td>\n <\/tr>\n
Marie<\/td>\n Leroy<\/td>\n Angers<\/td>\n marieleroy@laposte.net<\/td>\n <\/tr>\n
Vanessa<\/td>\n Savary<\/td>\n Marseille<\/td>\n vanessa13@gmail.com<\/td>\n <\/tr>\n
Jean<\/td>\n Bernard<\/td>\n Valenciennes<\/td>\n jbernard@gmail.com<\/td>\n <\/tr>\n<\/tbody>\n<\/table>\n\t\t\t

Develop your SQL skills with Liora<\/h2>
\"Computer<\/figure>\t\t\n\t\t

Manipulating relational data doesn’t just mean adding new information. It’s also possible to delete, modify, update and so on.<\/p>

For all these actions, there are a multitude of SQL queries<\/a>. If you want to know them all, data training is more than necessary. That’s why we’ve developed Liora.<\/p>

We offer a range of industry-specific training courses to help you develop your skills.<\/strong><\/p>\t\t\n\t\t\t\n

Start your SQL training<\/a><\/div><\/div>\n\n\t\t

? Related articles: <\/strong><\/p><\/colgroup>
SQL DELETE: How do I use this query?<\/a><\/td><\/tr>
SQL Developer: What is it? What’s it for?<\/a><\/td><\/tr>
SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr>
SQL joins: everything you need to know about table associations<\/a><\/td><\/tr>
SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr>
NoSQL: All about non-relational databases<\/a><\/td><\/tr><\/tbody><\/table>","protected":false},"excerpt":{"rendered":"

To insert data into your SQL table, you can use the INSERT INTOSQL query. But how does it work? That’s what we’re going to look at in this article. What is an INSERT INTO SQL request? INSERT INTO SQL is one of the most commonly used commands in the SQL language. And with good reason: […]<\/p>\n","protected":false},"author":76,"featured_media":207384,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2434],"class_list":["post-176446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-dev"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/176446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/76"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=176446"}],"version-history":[{"count":4,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/176446\/revisions"}],"predecessor-version":[{"id":207385,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/176446\/revisions\/207385"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/207384"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=176446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=176446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}