Row Order On Csv Import

[peterlaursen]

when you click the title bar to sort data is affects only how data are displayed.

Actually SQL databases are not designed in a way so that 'raw order' matters. It also depends on the storage Engine (myISAM/InnoD:cool: whether 'unused space' are filled with data or not.

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!

[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