-
SQL error
CREATE TABLE `access` (
`aid` int(10) NOT NULL default '0',
`usergroupID` int(11) NOT NULL default '0',
`access_type` int(3) NOT NULL default '0',
PRIMARY KEY ('aid')
) TYPE=MyISAM
There seems to be an error there somewhere, am i just being blind 'cause i can't see it?
-
CREATE TABLE access(
aid int( 10 ) NOT NULL PRIMARY KEY default 0,
usergroupID int( 11 ) NOT NULL default 0,
access_type int( 3 ) NOT NULL default 0
) TYPE = MYISAM
That works in phpMyAdmin. Unless your useing a version of mysql thats older than 3.23 you shouldnt to my knowledge need to define the type as MYISAM since that is now the default structure that MySQL follows. :)
-
-
It wasn't down to that. It was down to me using ' in one line as opposed to ` :) Cheers anyway