show tables

[glassdog]

Hello i am tring to get a module (zlteam) i used on an older version of phpnuke to work in 6.5. I am having troble with the table portion, after running the sql and creating the table. When i try to go into the table using show table; i get the following error from within mysql> You hanve an error in your SQL syntax near 'nuke_team' at line 1 ERROR 1064

this is what i used to write the table
Quote:
CREATE TABLE nuke_team (
tid int(11) NOT NULL auto_increment,
nname varchar(255) NOT NULL default '',
vname varchar(255) NOT NULL default '',
vage varchar(255) NOT NULL default '',
vgender varchar(255) NOT NULL default ''
stellung varchar(255) NOT NULL default '',
beschr_kurz text NOT NULL,
beschr_lang text NOT NULL,
pos int(11) NOT NULL default '0',
anzeigen int(11) NOT NULL default '0',
PRIMARY KEY (tid),
UNIQUE KEY tid (tid),
UNIQUE KEY pos (pos)
) TYPE=MyISAM;

thanks
Glassdog

[steadyguy]

You missed a comma:

vgender varchar(255) NOT NULL default ''

should be:

vgender varchar(255) NOT NULL default '',

On a totally different note ... gender only has a few choices which are mutually exclusive ... you could insert this line, instead, to save quite a bit of space:

vgender ENUM('male', 'female', 'other') NOT NULL DEFAULT 'other',

And ages are more likely to be TINYINT UNSIGNED, or VARCHAR(10) (ie: '255', or '1234 years', respectively) Either choice would use quite a bit less space than VARCHAR(255).

[glassdog]

Thank you for both points i will try those changes and see how it works out
Glassdog

[Weedpacket]

Note that storing ages as varchar(10) is still silly, because you're (a) using at least ten bytes to store something that could easily fit in one (as a one-byte int); (b) it would mean that ages would be sorted so that 1 < 10 < 2.