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]

Reply via email to