mySQL error, pls help

software development

#1

can somepme pls point me wht is wrong with these codes:

CREATE TABLE stx_l10n_en_US (
id varchar(255) NOT NULL default ‘’,
page_id varchar(255) default NULL,
text mediumtext,
PRIMARY KEY (id),
KEY page-based (page_id)
) TYPE=MyISAM;

Thanks


#2

what error message do you get when you try to run that query? nothing jumps out at me other than i’m not sure page-based is a valid key name due to the hyphen in it.


#3

the second to last line, says, page-based…

try using page_based … i think using the hyphen (minus sign) is where ur problem is

Putting the ‘Connect’ in Connecticut… All Things Computer … Effective Office Solutions … Pioneering Computers Since the early '80s!