Ok, I want to create a new table. I've tried variations of this query, and get various (but similar) errors. This last one was straight from the table-creation form on the (I think) latest version of phpmyadmin.
Error
SQL-query :
CREATE TABLE `site_items` (
`id` TINYINT( 2 ) NOT NULL AUTO_INCREMENT,
`bullet` TINYINT( 2 ) NOT NULL ,
`type` VARCHAR( 7 ) NOT NULL ,
`title` VARCHAR( 40 ) NOT NULL ,
`date` VARCHAR( 20 ) NOT NULL ,
`url` VARCHAR( 50 ) NOT NULL ,
`content` LONGTEXT( 500 ) NOT NULL ,
INDEX ( `id` )
)
MySQL said:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(500) NOT NULL, INDEX (`id`))' at line 1
Back