Results 1 to 4 of 4

Thread: SQL error

  1. #1
    Senior Member Kezzer's Avatar
    Join Date
    Sep 2003
    Posts
    4,863
    Thanks
    12
    Thanked
    5 times in 5 posts

    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?

  2. #2
    Flak Monkey! Dorza's Avatar
    Join Date
    Jul 2003
    Location
    UK - South Wales
    Posts
    1,762
    Thanks
    34
    Thanked
    17 times in 15 posts
    • Dorza's system
      • Motherboard:
      • Asus P5B Deluxe - WiFi
      • CPU:
      • Q6600 @ 3.06Ghz
      • Memory:
      • 2GB Crucial
      • Storage:
      • 500GB Samsung SpinPoint
      • Graphics card(s):
      • Geforce 9600GT
      • PSU:
      • Cosair HX520W
      • Case:
      • LianLi something something or other
      • Monitor(s):
      • Eizo FlexScan S1910 (1280*1024)
      • Internet:
      • 2mb Virgin (when they want to give me that: else 1mb)
    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.
    Last edited by Dorza; 24-06-2005 at 03:12 AM.

  3. #3
    Senior Member
    Join Date
    Mar 2005
    Location
    Letchworth Garden City
    Posts
    256
    Thanks
    0
    Thanked
    0 times in 0 posts
    No quotes is correct

  4. #4
    Senior Member Kezzer's Avatar
    Join Date
    Sep 2003
    Posts
    4,863
    Thanks
    12
    Thanked
    5 times in 5 posts
    It wasn't down to that. It was down to me using ' in one line as opposed to ` Cheers anyway

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SQL Server Connection string?
    By Stoo in forum Software
    Replies: 7
    Last Post: 04-05-2005, 05:48 PM
  2. Did my OC cause this?
    By myth in forum PC Hardware and Components
    Replies: 19
    Last Post: 05-04-2005, 12:36 PM
  3. A strange error Please help
    By Jambo in forum Help! Quick Relief From Tech Headaches
    Replies: 10
    Last Post: 03-04-2005, 05:09 PM
  4. bsod error
    By MuTTy_Hc in forum Software
    Replies: 3
    Last Post: 26-09-2004, 08:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •