[Tony H.]

peterlaursen wrote on Oct 30 2006, 12:21 AM:

Basically you are supposed to use and ORDER BY clause when generating a result set. You export and import and keep the order you could try

Code:

SELECT INTO OUTFILE …. ORDER BY…

that will generate a sorted SQL-file. But how the server stores the data when they are stored, SQLyog cannot control!

Hi Peter

Thanks for the reply! I hadn't even thought about doing a simple ORDER BY query, but it should work just fine!

Thanks!

Tony

[Author]

Posts