|
|
insert data from one table to another table - Mysql
|
Views : 699
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
insert data from one table to another table:
INSERT table2 (id, lname, fname)
SELECT id, lname, fname
FROM table1
WHERE State = 'TN';
Replace the VALUES clause with a SELECT statement that will return a set of records.
Before doing this confirm make sure that the table1 has all the values you want to insert. |
|
By Ramya, On - 2008-11-24 |
|
|
|