Mysql update query for update all users data

Question

I want a Mysql query to update all users 'status' filed in 'user' table. I can update one user by running following query.

Table

What I tried

update user set status = 1 where id = 1 and type = 'viber'

Do I need to run the above query inside a loop to update all users data?

I want a query like following

update user set status = 1 where id = 1 and type = 'viber' and id = 2 and type = 'twitter' ..

your help is much appreciated.

http://stackoverflow.com/questions/3432/multiple-updates-in-mysql — Shanu k k, Jan 24 '17 at 07:09
if you want to update all status in the table you need to remove your WHERE clause in your query something like this : UPDATE table_name SET Status = 1; — Adhan Timothy Younes, Jan 24 '17 at 07:16

score 4 · Accepted Answer · answered Jan 24 '17 at 07:05

4

Just

update user set status=1;

Updates your whole table.

answered Jan 24 '17 at 07:05

Hikmat Sijapati

6,869
1
9
19

score 1 · Answer 2 · answered Jan 24 '17 at 07:07

1

If you want to just update the status for all records then below query is useful for that.

update user set status=1;

answered Jan 24 '17 at 07:07

Harsh Barach

947
9
18

score 0 · Answer 3 · answered Jan 24 '17 at 07:21

0

The WHEREclause is used to extract only those records that fulfill a specified criterion. but here you don't want that .so just use this query to update all the records

update user set status=1;

answered Jan 24 '17 at 07:21

JYoThI

11,977
1
11
26

score 0 · Answer 4 · answered Jan 24 '17 at 08:42

just use:

$update = mysqli_query("UPDATE user SET status = 1")or die(mysqli_error());

if this not works, you can select all data and then update each row by setting user id like this :

$select =  mysqli_query("SELECT * FROM user")or die(mysqli_error());
while($row = mysqli_fetch_array($select)){
    $id = $row['id'];
    mysqli_query("UPDATE user SET status=1 WHERE id='$id' ");
}

Mysql update query for update all users data

4 Answers4