[mysql]

user table 생성

mysql> drop database if exists sqlDB;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> create database sqlDB;
Query OK, 1 row affected (0.00 sec)

mysql> use sqlDB;
Database changed
mysql> create table usertbl
    -> ( userid char(20) not null primary key,
    -> name varchar(20) not null,
    -> birthyear int not null,
    -> addr char(20) not null,
    -> mobile1 char(20),
    -> mobile2 char(20),
    -> height smallint,
    -> mdate datetime
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql>

구매 테이블 생성

mysql> create table buytbl (

num int auto_increment not null primary key,

userid char(20) not null,

prodname char(20) not null,

groupname char(20), price int not null,

amount smallint not null,

foreign key (userid) references usertbl(userid));
Query OK, 0 rows affected (0.01 sec)

mysql>