mysql - I am trying to create a sql table in phpmyadmin, I'm getting 4 errors. This code works in phpmyadmin on my pc at my work but not on the pc at home -


create table employees(     employee_id int(11), primary key,     name varchar(200) not null,     hourly_pay decimal(10,2),     position enum('manager','helper','cashier','cleaner') not null,     employee_contact bigint(10) not null     ); 

here errors:

a comma or closing bracket expected. (near "not null" @ position 86)

unexpected beginning of statement. (near "10" @ position 120)

unexpected beginning of statement. (near "2" @ position 123)

unrecognized statement type. (near "position" @ position 132)

remove comma after int(11)

create table employees(     employee_id int(11) primary key,     name varchar(200) not null,     hourly_pay decimal(10,2),      position enum('manager','helper','cashier','cleaner') not null,     employee_contact bigint(10) not null     ); 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -