2.2.7.sql

来自「清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码」· SQL 代码 · 共 11 行

USE school
create table ICBC_Card(
       bank_id char(20),
       stu_card_id char (14) references stu_card(card_id) on delete cascade,
       restored_money decimal (10,2),
       constraint PK_Icbc_card Primary key (bank_id)
)
insert into  ICBC_Card values ( '9558844022312','05212567',15000.1);
insert into  ICBC_Card values ( '9558844023645','05212222',50000.3); 
select * from ICBC_Card;