graham23s Posted July 19, 2007 Share Posted July 19, 2007 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 Link to comment https://forums.phpfreaks.com/topic/60822-solved-mass-adding-an-entry-into-mysql/ Share on other sites More sharing options...
phat_hip_prog Posted July 19, 2007 Share Posted July 19, 2007 Is it 'update' a field or add an extra column to each. If it's 'update' then use 'update' without a 'where'. Link to comment https://forums.phpfreaks.com/topic/60822-solved-mass-adding-an-entry-into-mysql/#findComment-302593 Share on other sites More sharing options...
cooldude832 Posted July 19, 2007 Share Posted July 19, 2007 if its a new field simply make it have a default value of "6" and then you are all set Link to comment https://forums.phpfreaks.com/topic/60822-solved-mass-adding-an-entry-into-mysql/#findComment-302603 Share on other sites More sharing options...
graham23s Posted July 19, 2007 Author Share Posted July 19, 2007 thanks guys done:) Link to comment https://forums.phpfreaks.com/topic/60822-solved-mass-adding-an-entry-into-mysql/#findComment-302611 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.