JREAM Posted July 19, 2009 Share Posted July 19, 2009 Im wondering.. INSERT INTO `users` VALUES 0 WHERE ROW='notify' Basically I want to go through every user and insert the value 0 under the row titled 'notify', without having to know every user name. Kinda like.. SELECT * FROM `users` Quote Link to comment https://forums.phpfreaks.com/topic/166459-solved-easy-way-to-insert-same-value-into-all-fields-mysql/ Share on other sites More sharing options...
AwptiK Posted July 19, 2009 Share Posted July 19, 2009 INSERT INTO table (notify) VALUES ('0') ? Quote Link to comment https://forums.phpfreaks.com/topic/166459-solved-easy-way-to-insert-same-value-into-all-fields-mysql/#findComment-877797 Share on other sites More sharing options...
JREAM Posted July 19, 2009 Author Share Posted July 19, 2009 haha thanks Quote Link to comment https://forums.phpfreaks.com/topic/166459-solved-easy-way-to-insert-same-value-into-all-fields-mysql/#findComment-877798 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.