Appending and importing data

Question

Hi,

I am exporting from one table and importing to another table.

1. First i import 100 records, then i need to import next 500 records.
2. Instead of appending it imports that last 500 records, i want to append 100 +500 records.
3. Is there any option in that in mysql?

Thanks.

Answer 1

You should learn about how to use the LIMIT ... OFFSET clause. See the doc on SELECT for details.