No, raw viewing via phpmyadmin. We have some strange rules on our dates which mean that when it comes to processing the data its easier if it's in order before it goes in.
for example, we have a schedule running 24 hours a day, but the dates associated with the entries run from 6am to 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 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 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 finish. > >Anyone heard of this behaviour before? Maybe a mysql config blip? > >Adrian > > >*********************************************************************** >******************* > >Granada Sky Broadcasting Limited ("GSB") Franciscan Court, 16 >Hatfields, London SE1 8DJ Tel 020 7578 4040 Fax 020 7578 4035, >Registered in England No: 3101815. This e-mail and any attachments may >be confidential. If you have received this communication in error >please tell us by return e-mail or at the number's above and delete it, >and any copies of it. You must not use, disclose, distribute, print or >rely on this email. Unless clearly stated that this disclaimer should >not apply, this e-mail is not intended to create legally binding >commitments on behalf of GSB, nor do its contents reflect the corporate >views or policies of GSB. Although GSB routinely screens for viruses >GSB makes no representation or warranty as to the absence of viruses in >this e-mail or any attachments. > >Visit our website at http://www.gsb.co.uk > >*********************************************************************** >******************* > > > ****************************************************************************************** Granada Sky Broadcasting Limited ("GSB") Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 7578 4040 Fax 020 7578 4035, Registered in England No: 3101815. This e-mail and any attachments may be confidential. If you have received this communication in error please tell us by return e-mail or at the number's above and delete it, and any copies of it. You must not use, disclose, distribute, print or rely on this email. Unless clearly stated that this disclaimer should not apply, this e-mail is not intended to create legally binding commitments on behalf of GSB, nor do its contents reflect the corporate views or policies of GSB. Although GSB routinely screens for viruses GSB makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Visit our website at http://www.gsb.co.uk ****************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
