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
******************************************************************************************
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
