sql文建表

当所で必要なテーブル名とフィールドが中国語の場合  二つの種類の表を作ることができる文

CREATE  TABLE `  `(
   `  ID`  INT(4)  primary key auto_increment,
   `   `  VARCHAR(50)  UNIQUE,
   `  `   VARCHAR(50)  DEFAULT  '  ',
   `  `   INT(5)  DEFAULT 800 CHECK(  >=500 and    <=1800),
   `    `  datetime
)

CREATE  TABLE   1(
     ID  INT(4)  primary key auto_increment,
        VARCHAR(50)  UNIQUE,
       VARCHAR(50)  DEFAULT  '  ',
        INT(5)  DEFAULT 800 CHECK(  >=500 and    <=1800),
        datetime
)

データを挿入するコード

insert into   (   ,  ,  ,    )  VALUES('wh1','  ',900,'2013-04-02');
insert into   (   ,  ,  ,    )  VALUES('wh2',NULL,600,'2013-04-09');
insert into   (   ,  ,  ,    )  VALUES('wh3','  ',1203,'2013-05-02');
insert into   (   ,  ,  ,    )  VALUES('wh4','  ',1000,'2013-04-05');
insert into   (   ,  ,  ,    )  VALUES('wh5','  ',900,'2013-06-08');

create  TABLE    (
     ID INT(4)  primary key auto_increment,
       VARCHAR(50)   UNIQUE,
        VARCHAR(50)  REFERENCES    (   ),
       VARCHAR(50)  NOT null,
       VARCHAR(10)  DEFAULT ' ' CHECK(  =' ' OR   =' ') ,
       INT(5)
)

なぜか分かりません  defaultは必ず前に置いて後ろに置いてください。エラーが発生しました。  わからない  ああああああ
データを挿入する語句

INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg1','wh1','  ',' ',1250);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg2','wh1','   ',NULL,1310);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg3','wh2','  ',' ',2050);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg4','wh1','   ',' ',1850);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg5','wh3','  ',' ',1962);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg6','wh2','   ',' ',1830);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg7','wh4','  ',' ',1850);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg8','wh2','   ',' ',1750);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg9','wh3','  ',' ',1250);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg10','wh4','  ',' ',1850);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg11','wh3','  ',' ',1890);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg12','wh4','  ',' ',1550);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg13','wh2','   ',' ',2150);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg14','wh4','  ',' ',1850);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg15','wh1','  ',NULL,1910);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg16','wh2','  ',' ',2050);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg17','wh4','   ',' ',1850);
INSERT  INTO   (   ,   ,  ,  ,  )  VALUES('zg18','wh3','   ',' ',1962);

サプライヤー表を作成

create  TABLE     (
       ID  INT(4)  primary key auto_increment,
          VARCHAR(50)  UNIQUE,
          VARCHAR(50),
        VARCHAR(50),
          VARCHAR(50),
             VARCHAR(100) DEFAULT  '[email protected]' CHECK(     LIKE '%@%.%')   
)

データの挿入

INSERT  INTO     (    ,    ,  ,    ,    )  VALUES('s1','       ','  ','0532-83698754','[email protected]');
INSERT  INTO     (    ,    ,  ,    ,    )  VALUES('s2','       ','  ','0531-83698754','[email protected]');
INSERT  INTO     (    ,    ,  ,    ,    )  VALUES('s3','          ','  ','0531-83698684','[email protected]');
INSERT  INTO     (    ,    ,  ,    ,    )  VALUES('s4','     ','  ','83698684','[email protected]');
INSERT  INTO     (    ,    ,  ,    ,    )  VALUES('s5','     ','  ','83698684','[email protected]');

create TABLE    (
     ID  INT(4)  primary key auto_increment,
        VARCHAR(50)  REFERENCES    (    ),
        VARCHAR(50)  REFERENCES   (   ),
        VARCHAR(50)  UNIQUE,
      INT
)

追加データ

INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg1','or1','2003-09-02',5000);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s1','zg2','or2','2004-09-03',8600);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s1','zg1','or3','2003-09-02',12000);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg2','or4','2003-09-02',5000);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg1','or5','2003-09-02',5000);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s3','zg11','or6','2004-09-03',8600);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s4','zg13','or7','2003-09-02',12000);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s1','zg15','or8','2005-09-03',16600);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg4','or9','2003-09-02',8120);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg8','or10','2004-09-03',5784);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s4','zg8','or11','2003-09-02',19641);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg10','or12','2005-09-03',16600);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg9','or13','2003-09-02',8120);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg9','or14','2004-09-03',5784);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s4','zg7','or15','2003-09-02',19641);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg18','or16','2005-09-03',16600);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg5','or17','2003-09-02',8120);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg5','or18','2004-09-03',5784);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s4','zg15','or19','2003-09-02',19641);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg15','or20','2003-09-03',16600);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s5','zg16','or21','2003-09-02',8120);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg16','or22','2004-09-03',5784);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s4','zg17','or23','2003-09-02',19641);
INSERT  INTO    (    ,   ,    ,    ,  )  VALUES('s2','zg18','or24','2005-09-03',16600);