sql - Difficulty in creating a table in mysql database -

this question has answer here:

• i keep getting mysql error code #1089 1 answer

i have tried creating table manually in mysql database columns id, phone, email, password, paymwnt. here id primary key auto increment when click save, following error message displays

incorrect prefix key. used part isn't string, used length longer key part or storage engine not support unique prefix keys"

someone please help.

create table #user_table  ( userid int primary key identity(1,1),  last_name varchar(50),  first_name varchar(50) ); select * #user_table insert #user_table values('k','raj') 

sol:

userid  last_name   first_name 1           k         raj