随笔分类 -  数据库规范

mysql删除问题
摘要：下面这句话删除会有问题 DELETE FROM sys_cost_item WHERE cost_item_id IN (SELECT cost_item_id FROM sys_cost_item WHERE cost_item_name='无' AND cost_type_code!='FEE_ 阅读全文
posted @ 2016-08-24 14:27 黄昏的麦田 阅读(123) 评论(0) 推荐(0)
mysql客户端添加存储过程
摘要：DROP PROCEDURE IF EXISTS add_costItem;DELIMITER $$ CREATE PROCEDURE `cloud_org`.`add_costItem`() BEGIN #定义 变量 DECLARE costTypeId BIGINT; DECLARE costT 阅读全文
posted @ 2016-08-24 13:51 黄昏的麦田 阅读(1361) 评论(0) 推荐(0)