Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




Updating Fields' Value


UPDATE `blablabla`.`blabla_db` SET `work_y` = '1' WHERE `blabla_db`.`id` =1 LIMIT 1 ;

Ok, the one above only updates one field's value, it only updates id 1, which sets work_y to 1. What i want to know is how to update all ids at the same time, which sets work_y to 1. Is there a way to do that?




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread

    Copyright © 2005-08 www.BigResource.com, All rights reserved