load data question

[J S]

Hi,
I'm trying to load a file containing a set of updates e.g.
UPDATE url_table SET hits=3 WHERE 
url="http://cache.unicast.com/java60/HTMLad_utils/ad2applet.js";;
UPDATE url_table SET hits=2 WHERE 
url="http://abclocal.go.com/images/wabc/2003/wabc_images_whatsonseven.gif";;
UPDATE url_table SET hits=2 WHERE 
url="http://images.thestreet.com/tsc/hd_img/tscw2.gif";;
UPDATE url_table SET hits=2 WHERE 
url="http://newsimg.bbc.co.uk/nol/shared/fds/hi/business/market_data/img/maps/israel.gif";;
UPDATE url_table SET hits=2 WHERE 
url="http://www.resortvacationstogo.com/images/banners/country_3.gif";;
UPDATE url_table SET hits=2 WHERE 
url="http://www.nyc.gov/html/hpd/gif/nyclogo.jpg";;
UPDATE url_table SET hits=2 WHERE 
url="http://news.bbc.co.uk/sportacademy/img/nav_icons/cricket_on.gif";;

using the following SQL statement
LOAD DATA INFILE '/tmp/updates.txt' INTO TABLE url_table;
Query OK, 6326 rows affected (0.23 sec)
Record: 6326 Deleted: 0 Skipped: 0 Warnings: 25304
I tried SHOW WARNINGS; but mysql (version 4.0.15) said it was a syntax 
error. Is there any other way to see the warnings?

Thanks for any help. Is there anything obviously wrong that I'm missing 
here?
JS.

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]