On 01 Feb 2003 18:06:01 -0500 [EMAIL PROTECTED] (Brian V Bonini) wrote:
On Sat, 2003-02-01 at 16:47, Thomas Seifert 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..
Any thoughts...
where do you take a row-order from? and HOW are you uploading it into mysql?
if you don't use a order by-clause in a select you won't have a really
ordered result (only by accident).
LOAD DATA INFILE 'file.cvs' INTO TABLE table1 FIELDS TERMINATED BY ';';
the contnts of file .csv look like:
1;2002-02-01;New Dominion Pictures;Prosecutors - The Gosch Murder
Case;Beau Parcells;Dave Stevenson (victim's husband), Lead;yes;yes;yes
2;2002-02-01;Coastal;Prospecting;Zoe Whitaker;Corporate
Representative;yes;yes; 3;2002-02-01;Metro Video;Right Spirit Campaign
(Binge Drinking PSA), - Richmond, VA;Tom Downs;Jim
(Sailor)/Principal;yes;yes;
4;2002-02-01;Metro Video;Right Spirit Campaign (Binge Drinking PSA), -
Richmond, VA;Amie Hill;Spokesperson;;;
5;2002-02-01;Metro Video;Unit of Action (U.S. Army);Tim Smith;Col. Mike
Daniels (Principal);;yes;
6;2002-02-01;Metro Video;Colonial Williamsburg;Molly
Larkin;Mother/Wife;;yes;
7;2002-02-01;Commercial;Barton Ford;Dave Hobbs;Car Salesman;yes;yes;
8;2002-02-01;Commercial;Barton Ford;Jackie Jackson;Customer's Wife;;;
9;2002-02-01;Regent Films;First Lunch;Molly Larkin;Principal;yes;yes;
10;2002-02-01;Skillet Productions (televisio;Welcome Home;Molly
Larkin;Principal;yes;yes;
etc
You'd think they would load into the db just like that right? But they
do not. They just end up in some random order.
this doesn't have anything to do with php afaik.
as I said, try:
select * from table1 order by field1 ASC
replace the field1 with the field you have the number in (the first field in your
csv).
--
Thomas Seifert
mailto:[EMAIL PROTECTED]
http://www.MyPhorum.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php