Hello, I am trying to use phpmyadmin and I entered in this code
Can anyone help?
Help with what? Does it give you an error message? If so, what is the error?
Seems to me that the issue is you’re missing a column at the start of each set of values - you show an int, then an int, then a date, but the column names there are candidate_number, student_id and subject_id, which implies int, int, int.
But I’m just guessing.
not only that. there are also the string delimiters missing and a normalised table looks different.
Hello,
It is hard to tell your problem.
If you query is throwing syntax errors check out here all you got to do is paste your code in and hit “Build schema” and it will tell you your error and what line it is on.
Ok I don’t know what that is, can you explain
The error code was #1136 column count doesn’t match value count at row 1. You would be right if it was not a auto_increment. Does that help?
I am not an SQL expert, but I thought that with an auto-incrementing column such as a uid field, you don’t specify the column in the query - the only columns you need to list are those that you are providing a value for, and any others will be created with their default value, which might be a fixed value or might be an auto-incrementing value.
2 Likes
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.