E
08-23-2002, 06:03 AM
and how can i fix it....
this is wat it says when i try to make a table
SQL-query :
CREATE TABLE `download` (`id` MEDIUMINT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `userid` MEDIUMINT(10) NOT NULL, `link` MEDIUMTEXT(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DATE(20) NOT NULL)
MySQL said:
You have an error in your SQL syntax near '(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DA' at line 1
this is wat it says when i try to make a table
SQL-query :
CREATE TABLE `download` (`id` MEDIUMINT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `userid` MEDIUMINT(10) NOT NULL, `link` MEDIUMTEXT(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DATE(20) NOT NULL)
MySQL said:
You have an error in your SQL syntax near '(100) NOT NULL, `artist` TEXT(50) NOT NULL, `title` TEXT(75) NOT NULL, `date` DA' at line 1