sql table creation err 1064

[dannYmvb]

hi, i am using the following query to create a table but it shows err 1064

CREATE TABLE ms.report (
slipno VARCHAR(40),
verified VARCHAR(10),
discrip VARCHAR(80)
)
ENGINE = InnoDB;

[Piranha]

I haven't seen that you use two names with a dot between when you create tables. I think that is the problem, but don't know for sure.

You should have a primary key as well, something like the following:

CREATE TABLE ms_report (
slipno VARCHAR(40) primary key,
verified VARCHAR10,
discrip VARCHAR(80)
)
ENGINE = InnoDB;