CODEWITHSUNDEEP
mysqlsqlxamppmariadb
Nieprzyjaciel
Nieprzyjaciel

Reputation: 61

MariaDB syntax error

CREATE TABLE movie(
id int() NOT NULL AUTO_INCREMENT,
name varchar() NOT NULL,
type int() NOT NULL default 0,
year int() NOT NULL default 0,
leadactor int() NOT NULL default 0,
director int() NOT NULL default 0,
PRIMARY KEY(id),
KEY type(type.year)
);

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') NOT NULL AUTOINCREMENT default 0, name varchar() NOT NULL default 0, type ' at line 2

I have no idea how to fix this. I'm using the newest xampp version.

Upvotes: 1

Views: 782

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269633

Either remove the () after int or include a number. varchar() requires a value. And, the period in the last row should be a comma:

CREATE TABLE movie (
    id int NOT NULL AUTO_INCREMENT,
    name varchar(255) NOT NULL,
    type int NOT NULL default 0,
    year int NOT NULL default 0,
    leadactor int NOT NULL default 0,
    director int NOT NULL default 0,
    PRIMARY KEY(id),
    KEY type(type, year)
);

Here is a SQL Fiddle.

Upvotes: 1

Related Questions