mySQL query error

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Sky
Forum Commoner
Posts: 71
Joined: Wed Oct 02, 2002 4:00 pm

mySQL query error

Post by Sky »

CREATE TABLE `rp_weapons` (

`name` TEXT( 30 ) NOT NULL ,
`class` TEXT( 20 ) NOT NULL ,
`description` MEDIUMTEXT( 200 ) NOT NULL ,
`price` MEDIUMTEXT( 20 ) NOT NULL ,
`damage` MEDIUMTEXT( 200 ) NOT NULL ,
`id` TINYINT( 10 ) NOT NULL ,
UNIQUE (
`name`
)
)


that's what i got from phpmyadmin.... Wha'd i do? 8O
User avatar
mydimension
Moderator
Posts: 531
Joined: Tue Apr 23, 2002 6:00 pm
Location: Lowell, MA USA
Contact:

Post by mydimension »

thats not an error, thats the layout of that particular table.
User avatar
Sky
Forum Commoner
Posts: 71
Joined: Wed Oct 02, 2002 4:00 pm

Post by Sky »

Just so you know i'm not nuts i forgot the sintax error. fixed it at any rate
Post Reply