Re: [PHP] Re: Loading CSV data into MySQL
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 ASC replace the 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
Re: [PHP] Re: Loading CSV data into MySQL
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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Loading CSV data into MySQL
On 01 Feb 2003 16:47:23 -0500 [EMAIL PROTECTED] (Brian V Bonini) wrote: > Sorry for the OT question: > > 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). Regards, -- 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