98渣渣辉的博客

##建库 CREATE DATABASE bankDB; ##客户信息表 CREATE TABLE userInfo ( customerID INT PRIMARY KEY AUTO_INCREMENT NOT NULL, customerName CHAR NOT NULL, PID CHAR(18) NOT NULL, telephone CHAR(11) NOT NULL, address...

##建立userInfo的约束 ##身份证，唯一约束 ALTER TABLE userInfo ADD CONSTRAINT id_PID CHECK (len(PID)=18 OR len(PID)=15), ADD CONSTRAINT UQ_PID UNIQUE(PID); ##cardinfo的约束 ##，必填，默认为RMB, ##savingID,外键.openDate,默认为系统当前日...

##添加数据 INSERT INTO userinfo(customerName,PID,telephone,address) VALUES(‘张四龙’,‘123456789012345’,‘01067898978’,‘北京海淀’), (‘张艺龙’,‘321245678912345678’,‘0478-44443333’,‘山东一条街’), (‘张三龙’,‘123456789032145’,‘22...

######创建、使用客户友好信息视图 CREATE VIEW view_userInfo AS SELECT * FROM userInfo SELECT * FROM view_userInfo CREATE VIEW view_cardinfo AS SELECT cardIDAS 卡号,curID AS 货币种类,savingIDAS 存款类型,openDateAS 开户日期,openMo...