RE: [PHP] Loading CSV data into MySQL
| From: | John W. Holmes | Date: | Sun, 02 Feb 2003 01:07:42 +0000 |
| Subject: | RE: [PHP] Loading CSV data into MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-133943@lists.php.net to get a copy of this message | ||
> On Sat, 2003-02-01 at 17:25, John W. Holmes wrote:
> > > I'm loading a .csv file into MySQL, done it a million times but
for
> > some
> > > reason it is scrambling the row order. All the fields are making
it in
> > > correctly but the order of the rows seems to end up totally
random.
> > I've
> > > done this a million times and never saw this..
> >
> > So?
> >
> > Why does it matter to you what order the rows are in the database,
as
> > long as the right data is there? The order is irrelevant.
> >
>
> Because in this instance I need it to come out in the order it is
> actually in.
Then use an ORDER BY in your query. If you're relying on the database to
spit out rows in the order they went in, then you're wrong.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/