Hi We have a database on MySql 4 and it contains many tables. In each field in the table in the past were there was no data to display we simply left the field blank, we now want to replace a null entry with No Data
I have no problem doing this on an individual field in each table like so UPDATE mc_centralgirls SET mc_centralgirls.notes = "No Data" WHERE (((mc_centralgirls.notes) Is Null)); but it's a big job. Can I do this at table level across all fields, or ideally at database level ? Regards John Berman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
