AUTO_INCREMENT is not working in mysql8 :(

Question

CREATE TABLE IF NOT EXISTS `users` (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    org_id  int NOT NULL,
    phonenum int NOT NULL
)  ENGINE=INNODB;

INSERT INTO `users` VALUES (1, 'USER','abcd', 1, 1);

this throws an error : ERROR 1062 (23000) at line 13: Duplicate entry '1' for key 'users.PRIMARY'

Thank you for your help!

Answer 1

When a field is autoincrement, you generally don't write to it. Change your query to

INSERT INTO `users` (`username`,`password`,`org_id`,`phonenum`)
VALUES ('USER','abcd', 1, 1);

In this you are specifying the field names and their values.