Creating a Table With a Default

[Al Sparks]

I'm trying to install ProBIND, and I'm running mysql 4.1.20.

One of the ProBIND install scripts calls for tables to be created in MySQL, and 
I've culled it down to this:

mysql> CREATE TABLE zones (
    -> id INT(11) DEFAULT '1' NOT NULL AUTO_INCREMENT,
    -> PRIMARY KEY (id)                
    -> );
ERROR 1067 (42000): Invalid default value for 'id'


I've tried double quotes, changing it to INT(1), and still I get that error.

Any hints?
   === Al



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]