SQL»ù´¡

##   ɾ³ýÊý¾Ý¿â
drop  database  ecport;
##   ´´½¨Êý¾Ý¿â
create   database   ecport;
##   ʹÓÃÊý¾Ý¿â
use   ecport;

##   ¹ú¼Ò±í½á¹¹
create   table COUNTRY(
               country_id     int  primary key auto_increment,
               name           varchar(64)
             
               );
##   Ä£Äâ¹ú¼Ò±íÊý¾Ý              
INSERT INTO COUNTRY( name ) VALUES ('Öйú');

##   Ê¡·Ý±í½á¹¹
create   table PROVINCE(
               province_id     int  primary key auto_increment,
               name           varchar(64),
               country_id      int  references   COUNTRY(country_id)
               );
              
//    Ä£ÄâÊ¡·Ý±íÊý¾Ý
INSERT INTO province (province_id , name , country_id ) VALUES (1, '°²»Õ', 1);
INSERT INTO province (province_id , name , country_id ) VALUES (2, '±±¾©', 1);
INSERT INTO province (province_id , name , country_id ) VALUES (3, 'ÖØÇì', 1);
INSERT INTO province (pr