What about this? I will not take "AUTO INCREMENT" I tried removing
the underscore and putting `AUTO INCREMENT` , but im getting the same
error as before.
CREATE TABLE if not exists TASK (
`Payment Date` DATE,
ID INT AUTO_INCREMENT,
CaseNumber CHAR(12) NOT NULL,
Payment_Amount FLOAT(8,2),
INDEX CaseNumber ( CaseNumber ),
INDEX ID ( ID ),
INDEX ( ID )
);
On Fri, 05 Nov 2004 10:22:42 -0800, ian douglas <[EMAIL PROTECTED]> wrote:
> >>Put Purge into backticks.
> >>
> >>........
> >>
> >>`Purge` char(1),
> >
> > It worked great but I would like to know why, thank!
>
> It could be that 'purge' is a reserved word in MySQL. I wanted to have a
> table with a shortened name of 'description' by trying to create a table
> with a 'desc' field, and MySQL had problems with it too, because 'desc'
> is a reserved word to 'describe' a table definition. But, creating the
> table as
> `desc` varchar(20)
> worked just fine...
>
> -id
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
