RE: Load data: odd behaviour

2003-09-25 Thread Adrian Sill
o 6am, would you believe! So Friday 26th starts at 6am. 4am tonight is classified as 2003-09-25. It just helps to have the transmission order in place right from the start! Thanks Adrian -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 25 September 2003 14:32 To: Adrian

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