######创建、使用客户友好信息视图
CREATE VIEW view_userInfo
AS
SELECT * FROM userInfo
SELECT * FROM view_userInfo
CREATE VIEW view_cardinfo
AS
SELECT cardID
AS 卡号,curID
AS 货币种类,savingID
AS 存款类型,openDate
AS 开户日期,openMoney
AS 开户金额,balance
AS 余额,password
AS 密码,IsReportLoss
AS 是否挂失,customerID
AS 客户编号
FROM cardinfo
SELECT * FROM view_cardinfo
CREATE VIEW view_tradeinfo
AS
SELECT transDate
AS 交易日期,cardID
AS 卡号,transType
AS 交易类型,transMoney
AS 交易金额,remark
AS 备注
FROM tradeinfo
SELECT * FROM view_tradeinfo
#####使用事务模拟完成存款或取款业务
DELIMITER KaTeX parse error: Expected 'EOF', got '#' at position 51: …oney() BEGIN **#̲#设置全局错误总数默认为0**…
DELIMITER ;
查看事务
CALL usp_add_and_getMoney();
SELECT * FROM cardInfo
作者:Dream丶一刻
时间:2019-1-9 12:30
【欢迎留言分享】