Results 1 to 3 of 3

Thread: Code error

  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Unanswered: Code error

    I get an 1064 error when I use the following code:


    CREATE TABLE `record` (
    `record_id` int(11) NOT NULL auto_increment,
    `record_date` date NOT NULL,
    `record` text NOT NULL,
    PRIMARY KEY (`record_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;



    Could someone please tell me what's wrong and how to fix it?

  2. #2
    Join Date
    Apr 2005
    Location
    Lier, Belgium
    Posts
    122
    Quote Originally Posted by Dron31
    I get an 1064 error when I use the following code:


    CREATE TABLE `record` (
    `record_id` int(11) NOT NULL auto_increment,
    `record_date` date NOT NULL,
    `record` text NOT NULL,
    PRIMARY KEY (`record_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;



    Could someone please tell me what's wrong and how to fix it?
    There's nothing wrong with it. What MySQL version are you using?
    What is the text of the error message?

    --
    felix

  3. #3
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1
    Quote Originally Posted by Dron31
    I get an 1064 error when I use the following code:


    CREATE TABLE `record` (
    `record_id` int(11) NOT NULL auto_increment,
    `record_date` date NOT NULL,
    `record` text NOT NULL,
    PRIMARY KEY (`record_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;



    Could someone please tell me what's wrong and how to fix it?
    The error 1064 occurs due to Mysql version mismatch because different
    versions have different reserved words which if used by a previous version causes the error to occur.

Posting Permissions

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