This is not a number error in phpMyAdmin

Question

I am trying to create a user table this way:

But I am getting this error:

This is not a number

What am I doing wrong?

Answer 1

You need to provide the VARCHAR length (the number of characters). The length should be a numeric value. then you can get rid of the error.

Answer 2

INT type have 4 bytes storage capacity so you can only give max lenght of 11.

Check this for more details