Timeline for AUTO_INCREMENT is not working in mysql8 :(
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 6, 2023 at 3:01 | vote | accept | CommunityBot | ||
| Jan 6, 2023 at 2:56 | comment | added | Rohit Gupta | Dont forget to tick the answer | |
| Jan 6, 2023 at 2:54 | comment | added | user266713 | You're right! I wasn't removing the id column from the left hand side, thank you so much! | |
| Jan 6, 2023 at 2:52 | comment | added | Rohit Gupta | No, its saying that the number of row names (in this 4) does not match the count of items in the values. They do in the sample above. Do they match in your sql ? | |
| Jan 6, 2023 at 2:44 | comment | added | user266713 | ERROR 1136 (21S01) at line 13: Column count doesn't match value count at row 1 now it says the count doesnt match, this is throwing me off i thought auto increment should account for this | |
| Jan 6, 2023 at 1:32 | history | edited | Rohit Gupta | CC BY-SA 4.0 |
added 64 characters in body
|
| Jan 6, 2023 at 1:25 | comment | added | Rohit Gupta | Oops, they should have been backticks, have corrected it. | |
| Jan 6, 2023 at 1:24 | history | edited | Rohit Gupta | CC BY-SA 4.0 |
edited body
|
| Jan 6, 2023 at 1:24 | comment | added | user266713 | it didnt work : ERROR 1064 (42000) at line 13: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''id','username','password','org_id','phonenum') VALUES ('USER','abcd' at line 1 mysql Ver 8.0.31 for macos12 on arm64 (MySQL Community Server - GPL) | |
| Jan 6, 2023 at 1:15 | history | answered | Rohit Gupta | CC BY-SA 4.0 |