Menu

#7 error in your SQL syntax

open
nobody
None
5
2007-10-23
2007-10-23
Anonymous
No

mysql> CREATE TABLE gfxcodes (
-> x
-> x
-> codeVARCHAR(25) NOT NULL,
-> crcVARCHAR(128) NOT NULL,
-> expireINT NOT NULL
-> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'x
codeVARCHAR(25) NOT NULL,
crcVARCHAR(128) NOT NULL,
expireINT NOT NULL
)' at line 3

Discussion

  • Nobody/Anonymous

    Logged In: NO

    MySQL version 4.1.20

     
  • Nobody/Anonymous

    Logged In: NO

    CREATE TABLE gfxcodes (
    VARCHAR(25) NOT NULL,
    VARCHAR(128) NOT NULL,
    expire INT NOT NULL
    );
    seems to work.

     

Log in to post a comment.