DEFAULT '0'

hello
I try to create a table with this statment
CREATE TABLE referants (
id int(10) DEFAULT '0' NOT NULL auto_increment,
referant char(200) NOT NULL,
hits int(10) DEFAULT '0' NOT NULL,
UNIQUE id (id)
);

but MySQL return a error message
#1067 - Invalid default value for 'id'

and because I'm a beginner I don't know how to avoid this error

thanks for your help

bruno

bruno - bdf wrote:
> hello
> I try to create a table with this statment
> CREATE TABLE referants (
> id int(10) DEFAULT '0' NOT NULL auto_increment,
> referant char(200) NOT NULL,
> hits int(10) DEFAULT '0' NOT NULL,
> UNIQUE id (id)
> );
>
> but MySQL return a error message
> #1067 - Invalid default value for 'id'
>
> and because I'm a beginner I don't know how to avoid this error
>
> thanks for your help
>
> bruno
>
>

Answered in comp.databases.mysql.

Please cross-post instead of multi-posting.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================