[SOLVED] Mass adding an entry into mysql

[graham23s]

Hi Guys,

 

i have just realised i needed to add a number 6 to a field in mysql only thing is there is already 250 entries in, is there anyway i cann add 6 to all fields at the one time?

 

thanks guys

 

Graham

[phat_hip_prog]

Is it 'update' a field or add an extra column to each.

If it's 'update' then use 'update' without a 'where'.

[cooldude832]

if its a new field simply make it have a default value of "6" and then you are all set

[graham23s]

thanks guys done:)