All pastes #924614 Raw Edit

Stuff

public text v1 · immutable
·published 2008-03-01 15:16 UTC
rendered paste body
create table ORDER

(

    ORDER_ID                    bigint               not null,

    PAYMENT_NAME                 varchar(50)          not null,

    TYPEDELIVERY_NAME            varchar(60)          not null,

    PREFECTRURE_NAME             varchar(30)          not null,

    ORDER_TYPERECEIPT            varchar(30)                  ,

    ORDER_DATE                   varchar(20)                  ,

    ORDER_TIME                   varchar(20)                  ,

    ORDER_PAYPRICE              decimal(9,2)                  ,

    ORDER_INFODELIVERY           varchar(250)                  ,

    ORDER_DELIVERED             boolean                    ,

    ORDER_FULLNAME               varchar(70)                  ,

    ORDER_TOWN                   varchar(40)                  ,

    ORDER_ADDRESS                varchar(80)                  ,

    ORDER_POSTALCODE             varchar(20)                  ,

    ORDER_PHONE                  varchar(30)                  ,

    ORDER_MOBILE                 varchar(30)                  ,

    ORDER_EMAIL                  varchar(50)                  ,

    primary key (ORDER_ID)

);


ERROR 1064 (42000): 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 'ORDER
(
    ORDER_ID                    bigint               not null,
    PAYME' at line 1