學生資料庫建立的開始階段

you_carry_me發表於2017-11-05

 create database system;

 use system;

 create table a
    -> (sno char(10) primary key,
    -> sn char(20),
    -> sa int,
    -> ss char(10),
    -> sd char(10));

 create table c
    -> (cno char(10) primary key,
    -> cn char(30),
    -> pcno char(10));

 create table sc
    -> (sno char(10),
    -> cno char(10),
    -> g int);

 create table unpw
    -> (un char(10) primary key,
    -> pw char(10),
    -> qx int);

 insert into unpw value('admin',123456,0),('student',654321,1);


相關文章