Hello All,
From Recent Search , Vinay find good & quick solution for inserting record from one old table to new table, with specific columns
From Recent Search , Vinay find good & quick solution for inserting record from one old table to new table, with specific columns
INSERT INTO new_table (columns....)
SELECT columns....
FROM initial_table where [condition]
using this query we can insert some records form old table to new table with given condition.
thanks vinay for your solution.
SELECT columns....
FROM initial_table where [condition]
using this query we can insert some records form old table to new table with given condition.
thanks vinay for your solution.
No comments:
Post a Comment