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` 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') ? 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 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
Archived
This topic is now archived and is closed to further replies.