RE: Load data: odd behaviour

2003-09-25 Thread Adrian Sill
Sill Cc: [EMAIL PROTECTED] Subject: Re: Load data: odd behaviour How did you determine this? I hope not by the order returned when you select them. There is no order to the set returned unless you use an ORDER BY clause. Adrian Sill wrote: >Morning all, > >I've been using the same f

Re: Load data: odd behaviour

2003-09-25 Thread gerald_clark
How did you determine this? I hope not by the order returned when you select them. There is no order to the set returned unless you use an ORDER BY clause. Adrian Sill wrote: Morning all, I've been using the same format of text files to import monthly text files using LOAD DATA LOCAL INFILE into

Load data: odd behaviour

2003-09-25 Thread Adrian Sill
Morning all, I've been using the same format of text files to import monthly text files using LOAD DATA LOCAL INFILE into a table. It's been working fine until today when it decided to import the rows from the text file in a semi-random order instead of working through the file from start to fi