I have a database with a table in it that contains member profile information. I want to restore their avatars the default which will involve me deleting the entries already made. The table name is core_members and the field is called pp_main_photo.
I have used this:
UPDATE core_members SET pp_main_photo = NULL;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Is there something wrong with my code?
UPDATE core_members SET pp_main_photo = NULL WHERE pp_main_photo is not null;