CREATE TABLE filmy ( filmID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, filmTitle VARCHAR(64), filmTitlePL VARCHAR(64), width SMALLINT(4), height SMALLINT(4), size INT(10), volumNumber TINYINT NOT NULL, currentNumber TINYINT NOT NULL, codecID INT UNSIGNED NOT NULL, addDate DATE DEFAULT '0000-00-00' NOT NULL, userID INT NOT NULL );
dostaje taki blad:
Cytat
You have an error in your SQL syntax near '\'0000-00-00\' NOT NULL,
userID INT NOT NULL
);
userID INT NOT NULL
);
o co chodzi?