CODEWITHSUNDEEP
mysql
Sai Kumar Gowtham
Sai Kumar Gowtham

Reputation: 1

Error: 1064 error in sql query

This sql query generates Error 1064 in Mysql:

CREATE table batch(id number primary key, 
                   batchNumber varchar2(20), 
                   InitialDate date, 
                   UpdateDate date);

I'm not sure how to resolve that error after trying several things.

Upvotes: 0

Views: 33

Answers (1)

mrcheshire
mrcheshire

Reputation: 535

Try this instead:

Create table batch(id integer primary key,batchNumber varchar(20),InitialDate date,UpdateDate date);

I don't think number is a mysql data type (I used integer) and neither is varchar2 (I used varchar).

For reference:

https://dev.mysql.com/doc/refman/5.0/en/char.html

https://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

Upvotes: 1

Related Questions