Mysql increase value not working

mysql increase value not working

UPDATE user SET favorite = favorite +1 WHERE uID=101;

Can I see Your Aia

Or

The Blocks

and

What Extension You Use ? Deephost Extension

1 Like

Show your blocks.
Deep Host extension ?

I didn’t see + after favourite in your image

Use join block to concatenate strings
UPDATE user SET favorite = favorite
+
1 WHERE …

Deep Host extension

Please Don’t Use Deephost Extension . Use Taifun Method

2 Likes

Use

1 Like

Where is “+” signal ?

update

And wrap table name and column name with " quotes