Incorrect column specifier for column ‘anyvalue’ in phpmyadmin
This normally happens when you are assigning first column value with other than “int” and it is going to be an like primary key whether you assign it or not but the schema of phpmyadmin or mysql would detemince it as primary and mysql schema would determine the first column value as numeric value but we are assigning it as varchar or char etc. value that is going to create mis-confusion in data structure of mysql and afterwards phpmyadmin front-end tool.
So clean it by not assigning the first column value of a first table other than “int value” and whatsoever character you assign it but not less than “8”.
Hopes that would clear the error namely “Incorrect column specifier for column ‘number’ in phpmyadmin”
Thanks for reading !