How to update all MySQL table rows at the same time

Question

How do I update all MySQL table rows at the same time   For example  I have the table   id       ip      port         online status   1        ip1     port1                        2        ip2     port2                        3        ip3     port3                        4        ip4     port4                        5        ip5     port5                          I m planning to create cronjob and monitor some servers  but I don t know exactly how to update them all from the table at the same time  What are some examples on how to do that

User · Answer

Just add parameters  split by comma   UPDATE tablename SET column1    value1   column2    value2         see the link also MySQL UPDATE

User · Answer

UPDATE dummy SET myfield 1 WHERE id gt 1

User · Answer

The default null value for a field is  not null   So you must set it to  null  before you can set that field value for any record to null  Then you can   UPDATE  myTable  SET  myField    null

User · Answer

Omit the where clause   update mytable set column1   value1  column2   value2  -- other column values etc     This will give all rows the same values   This might not be what you want - consider truncate then a mass insert   truncate mytable  -- delete all rows efficiently insert into mytable  column1  column2       values  row1value1  row1value2        -- row 1  row2value1  row2value2        -- row 2 -- etc

User · Answer

just use UPDATE query without condition like this  UPDATE tablename SET online status 0

User · Answer

update mytable set online status    online    If you want to assign different values  you should use the TRANSACTION technique

User · Answer

You can try this   UPDATE  tableName  SET  field1     your data    field2     your data      WHERE 1   1    Well in your case if you want to update your online status to some value  you can try this   UPDATE thisTable SET online status    Online  WHERE 1   1    Hope it helps   D

[mysql] How to update all MySQL table rows at the same time?

Examples related to mysql