-3
create table Employee(
     employeeID long(2) 
     , employeeName String(20)
     , joinDate Date
     , email String(50)
     , age int(2)
     , salary double(10)
     , address String(50)
)
Emilio Gort
  • 3,475
  • 3
  • 29
  • 44
Er. Ankit Kadam
  • 1
  • 1
  • 1
    `long` and `String` are not valid [data types](https://dev.mysql.com/doc/en/data-types.html) in MySQL. `DOUBLE` *is* a valid data type, but if you specify an optional precision then it must involve *two* parts. – eggyal Mar 23 '15 at 19:36
  • read this http://stackoverflow.com/questions/23515347/how-can-i-fix-mysql-error-1064#answer-23515348 it's a very good answer from @eggyal – Emilio Gort Mar 23 '15 at 20:13

1 Answers1

0

Try this instead:

CREATE TABLE Employee
(
    employeeID double,
    employeeName varchar(20),
    joinDate Date,
    email varchar(50),
    age int(2),
    salary double,
    address varchar(50)
)
Chris Forrence
  • 10,042
  • 11
  • 48
  • 64
Iftikhar Ali Ansari
  • 1,650
  • 1
  • 17
  • 27