{ this is a resend, forgot subject in original posting }
Hello, I am using MySQL 4.0.24 on OpenBSD 3.8.
I am having difficulty creating a SQL schema. My attempts contain
lines like:
CREATE TABLE users (
id PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
policy_id integer unsigned NOT NULL DEFAULT '1',
email varchar(255) NOT NULL,
fullname varchar(255) DEFAULT NULL,
local char(1),
KEY email (email)
);
Resulting in this error:
ERROR 1064 at line 1: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the
right syntax to use near 'PRIMARY KEY,
priority integer NOT NULL DEFAULT '7',
I think there is an incompatibility between my server version and
this statement but I can't figure out what it is. What should be
changed near PRIMARY KEY? This is for Spamassassin and amavisd-new.
__________________________________________________________
Find your next car at http://autos.yahoo.ca
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
