0
I own this table code
CREATE TABLE news (
id_news INTEGER NOT NULL,
title VARCHAR(128) NOT NULL,
slug VARCHAR(128) NOT NULL,
text TEXT NOT NULL,
PRIMARY KEY (id_news),
KEY slug (slug)
);
That is presenting the following error
Statement failed, SQLSTATE = 42000
-Dynamic SQL Error
-SQL error code = -104
-Token unknow - line 7, column 18
-(
I believe the problem is in the "KEY Slug(Slug)" part, I would like an explanation of what this attribute means and the reason for the error.
Possible duplicate of Problem with SQL in Firebird
– EMBarbosa