Re: nebiew migrate access tables to mysql

[ian douglas]

replied to him privately with this before I realized he'd sent a 
different copy with the list CC'd:

CREATE TABLE if not exists TASK (
  `Payment Date`  DATE,
  ID INT AUTO_INCREMENT,
  CaseNumber      CHAR(12) NOT NULL,
  Payment_Amount  FLOAT(8,2),
  PRIMARY KEY (ID),
  KEY CaseNumber ( CaseNumber )
);

spiv007 wrote:
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]