breeze351
asked on
Export select records from a SQL table
I need to export certain records from a table and then import them into another table.
SELECT * FROM `survey_data` WHERE `UPDATE_DAT` < "20161001"
These are the records that I want.
How do I import them into the 'history' table?
Glenn
SELECT * FROM `survey_data` WHERE `UPDATE_DAT` < "20161001"
These are the records that I want.
How do I import them into the 'history' table?
Glenn
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks