ON DUPLICATE KEY UPDATE не работает, что делать?

Question

[Семён Катапаров]

ON DUPLICATE KEY UPDATE не работает, что делать?

$steamid = $steamprofile['steamid'];
        $nickname = $steamprofile['personaname'];
        $current_date = date("l dS of F Y h:i:s A");

        $query = "INSERT INTO users (steamid, nickname, joined, balance, totalBought, banned, admin) VALUES ('$steamid', '$nickname', '$current_date', '0', '0', '0', '0') ON DUPLICATE KEY UPDATE nickname = '$nickname'";
        $userInfo = mysqli_query($connect, $query);

Answer 1

[Дмитрий Энтелис]

CREATE TABLE `users` (
 `steamid` varchar(255) NOT NULL,
 `nickname` text NOT NULL,
 `joined` text NOT NULL,
 `balance` text NOT NULL,
 `totalBought` text NOT NULL,
 `banned` text NOT NULL,
 `admin` int(11) NOT NULL,
 PRIMARY KEY (`steamid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Comments

[Семён Катапаров]

CREATE TABLE `users` (
`steamid` text NOT NULL,