摘要: MariaDB CURSOR示例一:简单创建CURSO并打开,关闭操作DELIMITER //CREATE PROCEDUREprocessorders() BEGIN DECLAREordernumbers CURSOR FOR SELECT order_num FROM orde... 阅读全文
posted @ 2016-03-20 20:58 李庆喜 阅读(280) 评论(0) 推荐(0) 编辑
摘要: MariaDB PROCEDURE创建不带参数的PROCEDUREDELIMITER //CREATE PROCEDUREproductpricing() BEGINSELECT Avg(prod_price) AS priceaverageFROM products; END;//DELIM... 阅读全文
posted @ 2016-03-20 19:49 李庆喜 阅读(160) 评论(0) 推荐(0) 编辑
摘要: MariaDB VIEWVIEW支持UPDATE,INSERT,DELETE ,但虚拟表只上将操作转移到了真正的表上示例一:替换复杂的JOIN(jlive)[crashcourse]>SELECT cust_name, cust_contact, prod_idFROM customers, ... 阅读全文
posted @ 2016-03-20 19:22 李庆喜 阅读(235) 评论(0) 推荐(0) 编辑