Field name LEFT and RIGHT

Mon, 09 Jul 2001 08:40:06 -0700 

Hi,

I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the 
following but it doesn't work:

CREATE TABLE WI_POSITION (
    PICTUREFILE   VARCHAR(200) NOT NULL,
    PICFILEXT     VARCHAR(5),
    POSITIONNO    VARCHAR(10) NOT NULL,
    SEQUENCENO    VARCHAR(3),
    LEFT          NUMERIC(4,0) NOT NULL,
    TOP           NUMERIC(4,0) NOT NULL,
    RIGHT         NUMERIC(4,0) NOT NULL,
    BOTTOM        NUMERIC(4,0) NOT NULL,
    UNIQUE POSITION_XPK (PICTUREFILE,POSITIONNO,SEQUENCENO)
);

and

CREATE TABLE WI_POSITION (
    "PICTUREFILE"   VARCHAR(200) NOT NULL,
    "PICFILEXT"     VARCHAR(5),
    "POSITIONNO"    VARCHAR(10) NOT NULL,
    "SEQUENCENO"    VARCHAR(3),
    "LEFT"          NUMERIC(4,0) NOT NULL,
    "TOP"           NUMERIC(4,0) NOT NULL,
    "RIGHT"         NUMERIC(4,0) NOT NULL,
    "BOTTOM"        NUMERIC(4,0) NOT NULL,
    UNIQUE POSITION_XPK (PICTUREFILE,POSITIONNO,SEQUENCENO)
);

But nothing works. How should I do?

Best regards

Joacim Järkeborn

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to