Another way to do it, create a temporary table load the content of your text file in it, and then do your update crossing the two tables.
Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]