Hi all, I am using mysql 3.23.49 solaris platform. I used load data local infile command to load tables. I got NULL entries in my rows (i.e. some rows have null in all fields) and since I executed this command twice I got same entries twice.
I tried to remove null rows by doing: delete from book where subject='NULL'; But it didn't work, also how to delete identical rows? -Pushkar S. Pradhan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php