I have just inserted a new coloumn into an existing mysql table that has been in use for quite a while. I would like to insert the value 'sold' into that coloumn for every record that exists within the table.
is there a mysql line that i can type into the command line that will do this for me?
Thanks!