sql replace a column/row in one time ?

[Squashing]

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?

[MentaL]

[Miller]

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

[Luxray]

UPDATE furniture SET stack_heigth = 1;

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

[Squashing]

UPDATE furniture SET stack_heigth = 1;

thankyou

[Luxray]

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

Editted my post.

[Squashing]

Editted my post.

Thankyou so this will be it:

UPDATE furniture SET stack_heigth = 1 WHERE stack_height = 0.1;

[Luxray]

Thankyou so this will be it:

UPDATE furniture SET stack_heigth = 1 WHERE stack_height = 0.1;

Exactly