Mysql phpmyadmin error "this is not a number"

Posted by faadoocoders at 11:10 PM Read our previous post

Mysql phpmyadmin error "this is not a number"

hey guys hope you have a good day,

Today a was developing a Java app. which a mysql database. I used the famous tool phpmyadmin for that task.

while creating a table in my database in mysql in Xampp server i have got an error “this is not a number”. I have search on the web for it and a very less people had the right answer.

While creating columns of the table you might have forgotten to give the length of the datatype of the coloumn.
for ex.
The name of the table is register,there is 1 column in it i.e Name
Now you chose its TYPE as VARCHAR and forgot to give the LENGTH of VARCHAR i.e leave it blank.
So when you save it it will give this error.
Better give the length of the data type , to and the table will be saved.


 Don’t forget to set the length field to get away from that fool error :D