How to insert data for one column for all the rows in single query in Mysql?

Question

+----+------------+------------+------------+----------+
| id | phone_no   | join_date  | city       | blood_gp |
+----+------------+------------+------------+----------+
|  1 | 80077672xx | 1997-07-19 |  Delhi     | NULL     |
|  2 | 80077642xx | 1998-07-19 | New Delhi  | NULL     |
|  3 | 80477642xx | 1999-07-19 | Mumbai     | NULL     |
|  4 | 80077654xx | 1997-05-31 | Kolkata    | NULL     |
+----+------------+------------+------------+----------+

I want to enter all the blood groups at once . Is there a way to do so ?

can you show your expected result after `UPDATE`? is there a source for the data? — Sebastian Brosch, Aug 24 '17 at 07:36
if you enter all value using single query then use this above — Shafiqul Islam, Aug 24 '17 at 07:38
Duplicate question : @Varad Bhatnagar https://stackoverflow.com/questions/25674737/mysql-update-multiple-rows-with-different-values-in-one-query — Chanchal Roshan, Aug 24 '17 at 07:42
Possible duplicate of [MYSQL - UPDATE multiple rows with different values in one query](https://stackoverflow.com/questions/25674737/mysql-update-multiple-rows-with-different-values-in-one-query) — MD Ruhul Amin, Aug 24 '17 at 07:44

Shafiqul Islam · Accepted Answer · 2017-08-24T07:53:12.503

1

you can use single query with select and update

UPDATE table1 , (SELECT * FROM table2 where 1) src 
  SET table1.blood_gp = src.filed2 where 1 ;

if you want to insert multiple row data using single query then use this code

INSERT INTO yourtable (x,y,z) VALUES (a1,a2,a3), (b1,b2,b3);

or if you want to update one column value all filed then use this code

update yourtable set blood_gp = 'yourvalue' where 1;

if any problem then inform me

edited Aug 24 '17 at 07:53

answered Aug 24 '17 at 07:41

Shafiqul Islam

5,570
2
34
43

@Varad Bhatnagar can you give me upvote? i did already so you can do that now – Shafiqul Islam Dec 05 '17 at 05:57

score 0 · Answer 2 · answered Aug 24 '17 at 07:38

0

Just make an update query without where clause.

update table set blood_gp = 'value'

That's generalize query.

answered Aug 24 '17 at 07:38

MD Ruhul Amin

4,386
1
22
37

What if i want to enter data which is not same for all rows ? – Varad Bhatnagar Aug 24 '17 at 07:39
then query would be different. – MD Ruhul Amin Aug 24 '17 at 07:43
I will have to use loop ? – Varad Bhatnagar Aug 24 '17 at 07:44
Yes, It would be a better option. As there will be different values for each individual id. – MD Ruhul Amin Aug 24 '17 at 07:45

How to insert data for one column for all the rows in single query in Mysql?

2 Answers2