sql replace a column/row in one time ?

Hi

I would like to change in table furniture in colum stack_height. I would like to change the value 0.1 to 1

Wich sql should I use?

Use Navicat and edit the column in 'Table Design'.

UPDATE furniture SET stack_heigth = 1;

add WHERE stack_height = 0.1 at the end if it matters.

Quote:

---

Originally Posted by Zoldyck

UPDATE furniture SET stack_heigth = 1;

---

thankyou

Quote:

---

Originally Posted by Squashing

I don't want all stack_height to be 1. Only the one that have the value of 0.1

---

Editted my post.

Quote:

---

Originally Posted by Zoldyck

Editted my post.

---

Thankyou so this will be it:

UPDATE furniture SET stack_heigth = 1 WHERE stack_height = 0.1;

Quote:

---

Originally Posted by Squashing

Thankyou so this will be it:

UPDATE furniture SET stack_heigth = 1 WHERE stack_height = 0.1;

---

Exactly