CREATETABLEcopy_carsLIKEcars;QueryOK,0rowsaffected(0.86sec)mysql>SELECT*fromcopy_cars;Emptyset(0.08sec)The following query using subquery will Insert the same value as "cars" into table "copy_cars" -mysql>INSERTINTOCopy_"/> CREATETABLEcopy_carsLIKEcars;QueryOK,0rowsaffected(0.86sec)mysql>SELECT*fromcopy_cars;Emptyset(0.08sec)The following query using subquery will Insert the same value as "cars" into table "copy_cars" -mysql>INSERTINTOCopy_">

Home >Database >Mysql Tutorial >How can we use MySQL subquery with INSERT statement?

How can we use MySQL subquery with INSERT statement?

王林
王林forward
2023-09-08 23:37:02867browse

我们如何将 MySQL 子查询与 INSERT 语句一起使用?

can be understood through an example in which we copy the values ​​of one table to another table. We are using data from table "cars" and copying its data to table "copy_cars" -

mysql> CREATE TABLE copy_cars LIKE cars;
Query OK, 0 rows affected (0.86 sec)

mysql> SELECT * from copy_cars;
Empty set (0.08 sec)

The following query using subquery will insert the same value as "cars" into table "copy_cars" -

mysql> INSERT INTO Copy_cars Select * from Cars;
Query OK, 8 rows affected (0.07 sec)

mysql> SELECT * from copy_cars;
+------+--------------+---------+
| ID   | Name         | Price   |
+------+--------------+---------+
| 1    | Nexa         | 750000  |
| 2    | Maruti Swift | 450000  |
| 3    | BMW          | 4450000 |
| 4    | VOLVO        | 2250000 |
| 5    | Alto         | 250000  |
| 6    | Skoda        | 1250000 |
| 7    | Toyota       | 2400000 |
| 8    | Ford         | 1100000 |
+------+--------------+---------+
8 rows in set (0.00 sec)

The above is the detailed content of How can we use MySQL subquery with INSERT statement?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete