MYSQL/PHP BATCH UPDATE

Question

I want to create a batch delete and/or update screen for records similar to how the iphone lets you batch delete text messages In other words when you click edit, it shows a checkbox next to all the records and you can then click a button that deletes them or changes a value.

I have discovered following syntax to insert a bunch of rows:

insert into tbl (...) values (...) (...) (...) ...

There also seems to be a way to batch delete using:

delete from tbl where id IN (1,2,3)

Is there a way to do a batch update?

I think I could then just collect an array of the id numbers for the records and run either a delete or update query depending on what button is pushed.

Himanshu · Accepted Answer · 2012-08-28 13:12:04Z

3

You can use WHERE condition same like you did for DELETE query like this:

UPDATE tbl SET col1='...', col2='...' WHERE id IN (1,2,3)

See this SQLFiddle

edited Aug 28, 2012 at 13:12

answered Aug 28, 2012 at 12:54

Himanshu

32.8k32 gold badges117 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1260310 Over a year ago

Thanks! First time I have seen sqlfiddle.

Collectives™ on Stack Overflow

MYSQL/PHP BATCH UPDATE

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related