0

i am creating a table employee which looks like this

use employeemaster;
drop table if exists  employee;
create table employee
(
  serial     int unsigned NOT NULL auto_increment,
  empid     tinytext  NOT NULL ,
  empname   varchar(255) NOT NULL,
  address   text NOT NULL
  mobile    bigint unsigned NOT NULL,
  grade    char(2) NOT NULL,
  basic    decimal(10,2) NOT NULL,
  
  primary key (mobile)
    
  
);

but in the command line when i run it it gives

error 1064(42000)
check the right syntax to use near 'mobile bigint unsigned NOT NULL,
                                    grade char(2) NOT NULL,
                                    basic deci' at line 7

please help!

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by joy39
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.