How to add value to a specific row in mysql?

Question

I want to add weight value to row 2. How do I do that? I tried to do the following but it gives me an error:

INSERT INTO name(member_id, weight) VALUES(2,55.6);

What is the mistake that I'm having?

Hi, welcome to StackOverflow. Do you mean you are trying to change the weight column value of the second row? If so, you need to update the row by member_id column. If you're trying to add a column to an existing table, you'll need an ALTER TABLE statement, something like: ALTER TABLE table ADD [COLUMN] column_name column_definition [FIRST|AFTER existing_column];. You can find more info here: — Selim Balci
– Selim Balci, Commented Dec 13, 2020 at 9:02

Hila DG · Accepted Answer · 2020-12-13 04:47:27Z

1

If you're updating a specific row you need to use the UPDATE command


   
UPDATE talbename
   SET weight =55.6
   WHERE member_id = 2

answered Dec 13, 2020 at 4:47

Hila DG

7346 silver badges14 bronze badges

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

Comments

Dust_In_The_Wind · Accepted Answer · 2020-12-13 04:48:23Z

1

You can use the UPDATE clause and use a WHERE condition to target a particular row -

UPDATE fromis_9
SET weight = 2
WHERE member_id = 2;

answered Dec 13, 2020 at 4:48

Dust_In_The_Wind

3,7229 gold badges51 silver badges87 bronze badges

2 Comments

Alabama Over a year ago

Out of range value for column 'weight' at row 1, this is the error

Dust_In_The_Wind Over a year ago

Well, your CREATE TABLE statement (from your screenshot) shows that you didn't add the weight column at the time of creating the table. Did you add in the correct data type when you added it in later?

Rishabh Kumar · Accepted Answer · 2020-12-13 05:36:30Z

1

INSERT INTO clause is used for inserting new records. To Update an existing record, UPDATE clause is used.

UPDATE fromis_9 SET weight = 55.6 WHERE member_id = 2;

answered Dec 13, 2020 at 5:36

Rishabh Kumar

2,4403 gold badges16 silver badges23 bronze badges

Comments

Michał Dziewa · Accepted Answer · 2020-12-13 04:48:29Z

0

Hi I think you should use INSERT INTO table where condition(member.id=2) please refer to https://www.w3schools.com/sql/sql_insert_into_select.asp Its better to learn how to read documentation than wait for complete answer ;)

answered Dec 13, 2020 at 4:48

Michał Dziewa

111 bronze badge

1 Comment

Michał Dziewa Over a year ago

I agree with answer below, i forgot that if you are inserting something in existing row you need to use update instad of insert (Too much spring)

Collectives™ on Stack Overflow

How to add value to a specific row in mysql?

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related