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