I have a huge text file, \r seperated, for example: 10065 10066 10067 10069 10070 10075 10091 10093 10094 10100 10103 10104 10107 10108 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 However, there are about 5000 numbers in it, I need a way to delete from table where old_id = one of the above numbers and then repeat on, is there a easy way to construct this statement, perhaps reading the data from a infile.
Mysql ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]