Posted by laredotornado on 10/02/06 12:44

Hi,

I'm trying to create a table in MySQL 5.0. The table created fine in
MySQL 4.0. The statement is

CREATE TABLE USER_GROUPS (
GROUP_ID INTEGER UNSIGNED DEFAULT 0 NOT NULL
AUTO_INCREMENT,
NAME VARCHAR(255),
CONSTRAINT PK_USER_GROUPS PRIMARY KEY (GROUP_ID)
) TYPE = INNODB;

and the error is

#1067 - Invalid default value for 'GROUP_ID'

What to do? Thanks, - Dave

• Next in forum: Re: MySQL 5 -- "Invalid default value"?
• Prev in forum: undefined function mysql_connect
• Thread view: MySQL 5 -- "Invalid default value"?

[Reply to this message]