Code error

Dron31 · #1 (**permalink**) 09-20-06, 10:49

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?

felixg · #2 (**permalink**) 09-21-06, 10:56

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

bstjean · #3 (**permalink**) 09-21-06, 11:25

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech