Update all rows in a MySQL table using single query

Question

I am wondering from 2 days but didn't get any suitable solution for my problem. I am working on a project and here I stuck on updating all rows of a MySQL table using single Update Query in PHP. Let's Suppose I have the table like given below

id |  heading  |  description
---------------------------
1    heading1    desc1

2    heading2    desc2

3    heading3    desc3

Now I want to update the heading, description fields using single update query. how will I loop the form for this ? can somebody suggest the easy and most efficient way to do this.

dude... have you tried anything or did your teacher just assign some homework and you want someone else to do it? — CptMisery
– CptMisery, Commented Nov 1, 2016 at 17:05

ScaisEdge · Accepted Answer · 2016-11-01 17:04:21Z

3

could be a simple updated

update my_table  
set heading  = 'my_value1',
    description = 'my_value2';

eventually you can add some where for proper filter

update my_table  
set heading  = 'my_value1',
    description = 'my_value2'
where heading = 'a_value';

edited Nov 1, 2016 at 17:04

answered Nov 1, 2016 at 17:02

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

1 Comment

ScaisEdge Over a year ago

What's the problem for 100 rows .. ? ... 100.000 ... 1000.000 .. and update is an update .. (if you need you can limit,, but if you don't nedd...no)

Collectives™ on Stack Overflow

Update all rows in a MySQL table using single query

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