mysql error

[Dorianek]

Hello, does anyone know how to fix this?

 

[Ramon Bernardo]

UPDATE `player_storage`

and not

UPDATE `player_storage

 

[Dorianek]

Yes, I know, but I have the following and the error is still there

CREATE TABLE `player_storage` (
  `player_id` int(11) NOT NULL DEFAULT 0,
  `key` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `value` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

[mano368]

Yes, I know, but I have the following and the error is still there

Because you don't tell the system whats to update, you only write 0...

What do you need to update? Value?

So use:

UPDATE `player_storage` SET `value` = 0 WHERE `key` = 74645