I'm sure I did something wrong here, but have any of you ever had problems with phpMyAdmin creating bad SQL syntax? I tried creating a table and this error came back to me:
MySQL said: You have an error in your SQL syntax near 'not null , date DATE not null , PRIMARY KEY (ID), INDEX (ID, wallpaperID), UNI' at line 1
Here's my table creation code:
CREATE TABLE wallpaper (ID TINYINT UNSIGNED not null AUTO_INCREMENT, wallpaperID MEDIUMINT UNSIGNED not null , title TEXT not null , description TEXT not null , keywords TEXT not null , views INT UNSIGNED DEFAULT '0' not null , status ENUM not null , date DATE not null , PRIMARY KEY (ID), INDEX (ID, wallpaperID), UNIQUE (ID, wallpaperID))
Is my ENUM causing the problem? Maybe because I didn't define the enumerated values? By the way, in which field using phpMyAdmin do I define the enumerated values?