Welcome to WebmasterWorld Guest from 220.127.116.11
I have about 3000 rows of data and even doing an update query after the import doesnt work. For example, "update table set date='2006-04-31' WHERE date='0000-00-00'" affects 0 rows even though the date for all of them is 0000-00-00 and I can delete them using this query "delete FROM `google_data` WHERE date='0000-00-00'".
Any idea whats going on? The field type is 'date', null is set to 'no', and Default is set to '0000-00-00'.