MySQL में एक टेबल से फ़ील्ड्स चुनकर दूसरी टेबल में INSERT कैसे करें?

पहली टेबल बनाएं

mysql> create table DemoTable1 (
    -> StudentId int,
    -> StudentName varchar(20)
    -> );
Query OK, 0 rows affected (0.64 sec)

रिकॉर्ड्स डालें

mysql> insert into DemoTable1 values(10,'John');
Query OK, 1 row affected (0.15 sec)
mysql> insert into DemoTable1 values(11,'Chris');
Query OK, 1 row affected (0.15 sec)

पहली टेबल के रिकॉर्ड्स देखें

mysql> select * from DemoTable1;

+-----------+-------------+
| StudentId | StudentName |
+-----------+-------------+
| 10        | John        |
| 11        | Chris       |
+-----------+-------------+
2 rows in set (0.00 sec)

दूसरी टेबल बनाएं

mysql> create table DemoTable2 (
    -> CustomerId int,
    -> CustomerName varchar(100)
    -> );
Query OK, 0 rows affected (0.82 sec)

SELECT के साथ INSERT क्वेरी

mysql> insert into DemoTable2(CustomerId,CustomerName) 
    -> select StudentId,StudentName from DemoTable1 where StudentId=11;
Query OK, 1 row affected (0.20 sec)
Records: 1  Duplicates: 0  Warnings: 0

दूसरी टेबल जांचें

mysql> select * from DemoTable2;

+------------+--------------+
| CustomerId | CustomerName |
+------------+--------------+
| 11         | Chris        |
+------------+--------------+
1 row in set (0.00 sec)

सिंटैक्स: INSERT INTO target_table (col1, col2) SELECT col1, col2 FROM source_table WHERE condition;