I dont see whats wrong with my sql but if someone could help me find the error it would be great. Heres the code
SQL-query :
CREATE TABLE news (author VARCHAR NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, message TEXT NOT NULL, title VARCHAR NOT NULL, PRIMARY KEY (author), INDEX (author, id), UNIQUE (id))
MySQL said:
You have an error in your SQL syntax near 'NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, messag' at line 1
SQL-query :
CREATE TABLE news (author VARCHAR NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, message TEXT NOT NULL, title VARCHAR NOT NULL, PRIMARY KEY (author), INDEX (author, id), UNIQUE (id))
MySQL said:
You have an error in your SQL syntax near 'NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, messag' at line 1