How can we insert values into a table with the help of MySQL self-computed output?

We can insert the values into a table with the help of the self-computed output returned by MySQL. In this case, we do not need to use dummy ‘dual’ table. The syntax can be as follows −

INSERT INTO table_name(column1,column2,column3,…) Select value1,value2,value3,…;

Example

In the example below, we have inserted the values in ‘testing’ table by using the MySQL self-computed output.

mysql> Create table testing(id int, item_name varchar(10));
Query OK, 0 rows affected (0.15 sec)

mysql> Insert into testing (id,item_name)Select 1,'Book';
Query OK, 1 row affected (0.11 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> Insert into testing (id,item_name)Select 2,'Pen';
Query OK, 1 row affected (0.11 sec)
Records: 1 Duplicates: 0 Warnings: 0

mysql> select * from testing;

+------+-----------+
| id   | item_name |
+------+-----------+
| 1    | Book      |
| 2    | Pen       |
+------+-----------+

2 rows in set (0.00 sec)

Jai Janardhan

Published on 19-Feb-2018 10:15:42

• Related Questions & Answers
• How can we use MySQL self-computed output from any expression, function etc. for inserting values in a row?
• How can we insert data into a MySQL table?
• How can we subtract values in MySQL table with the help of LEFT JOIN?
• How can we add values into the columns of a MySQL table?
• How can we insert a new row into a MySQL table?
• What is the way to get self-computed output from MySQL without a dummy table named dual?
• How can we use INSERT() function to insert a new string into the value of a column of MySQL table?
• Can we insert records in a MySQL table without auto_increment values?
• MySQL INSERT INTO SELECT into a table with AUTO_INCREMENT
• Auto insert values into a MySQL table in a range?
• How can we filter data with the help of MySQL subquery?
• How can we use WHERE clause with MySQL INSERT INTO command?
• How can we display all the records from MySQL table with the help of PHP script?
• Insert JSON into a MySQL table?
• How can we update values in a MySQL table?