954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

error 1064

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!

joy39
Newbie Poster
16 posts since Oct 2011
Reputation Points: 10
Solved Threads: 0
 

A comma is missing at the end of the previous line.
address TEXT NOT NULL,

smantscheff
Nearly a Posting Virtuoso
1,233 posts since Oct 2010
Reputation Points: 300
Solved Threads: 254
 

thanks!

joy39
Newbie Poster
16 posts since Oct 2011
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You