<div>
That works, structure is the same.<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
I need to export certain records from a table and then import them into another table.<br />
<br />
SELECT * FROM `survey_data` WHERE `UPDATE_DAT` &lt;&nbsp;&quot;20161001&quot;<br />
<br />
These are the records that I want.<br />
<br />
How do I import them into the 'history' table?<br />
<br />
Glenn
</div>
</div>


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

Export select records from a SQL table

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.