You are not telling the database where to update, put a where clause at the end. Instead of modifying every row, mysql just doesn't do it (to do every row, do WHERE 1=1)

__________________