随笔分类 - MySQL

MySql 事务+异常处理+异常抛出

摘要：-- 测试用表-- innodb 支持事务CREATE TABLE `tb_test` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)) ENGINE=INNODB ... 阅读全文

posted @ 2015-08-22 22:18 xachary 阅读(4109) 评论(0) 推荐(0) 编辑

Mysql 细节记忆

摘要：DELIMITER $$ 和 DELIMITER ;DROP PROCEDURE IF EXISTS `pro_follow_getBookBeforeExpired`$$DECLARE p_ServiceCode VARCHAR(50);SET p_ServiceCode = 'YYGH';IF ... 阅读全文

posted @ 2015-04-27 09:08 xachary 阅读(287) 评论(0) 推荐(0) 编辑

MySql查看表信息

摘要：SELECT TABLE_NAME, TABLE_COMMENT -- 指定信息列FROM `information_schema`.`tables` AWHERE A.`TABLE_SCHEMA` = '库名'AND A.`TABLE_COMMENT` = '' -- 其余条件阅读全文

posted @ 2015-02-12 14:38 xachary 阅读(429) 评论(0) 推荐(0) 编辑

MySql Update Select 嵌套

摘要：UPDATE `TB_CM_Dic` SET `ParentID` = (SELECT `ID` FROM (SELECT * FROM `TB_CM_Dic`) AS B WHERE `DicName` = '药品类别')WHERE `ID` = ( SELECT `ID` FROM(... 阅读全文

posted @ 2014-12-25 11:39 xachary 阅读(1591) 评论(0) 推荐(0) 编辑

MySQL 触发器的定义

摘要：-- InsertDELIMITER $$USE `testdatabase`$$DROP TRIGGER /*!50032 IF EXISTS */ `Trigger_XXX_INSERT`$$CREATE /*!50017 DEFINER = 'root'@'%' */ TRIGGE... 阅读全文

posted @ 2014-10-31 12:57 xachary 阅读(588) 评论(0) 推荐(0) 编辑

MySQL Update 使用

摘要：备忘:USE `xxx`;SET SQL_SAFE_UPDATES = 0;UPDATE `TB_MB_1` TSET T.`MedicalCount` = ( SELECT S.Total-- ,S.`HospitalID` FROM( SELECT DISTIN... 阅读全文

posted @ 2014-10-15 19:49 xachary 阅读(283) 评论(0) 推荐(0) 编辑

Entity Framework with MySQL

摘要：Get Entity Framework:http://msdn.microsoft.com/en-us/data/ee712906Entity Framework 6 Tools for Visual Studio 2012 & 2013:http://www.microsoft.com/en-u... 阅读全文

posted @ 2014-09-22 19:25 xachary 阅读(150) 评论(0) 推荐(0) 编辑

EF 事务处理 (InnoDB Engine的MySQL表也可以)

摘要：备忘1. 亲测(可以嵌套使用)using (TransactionScope scope = new TransactionScope()){ //操作1 XXEntities.Current.SaveChanges(); //操作2 XXEntities.C... 阅读全文

posted @ 2014-09-19 11:32 xachary 阅读(386) 评论(0) 推荐(0) 编辑

.NET MySQL的参数化查询

摘要：MySqlConnection conn = new MySqlConnection(SqlConnnectString);MySqlCommand cmd = new MySqlCommand("SELECT * FROM `TB_CM_Log` WHERE ID = ?ID LIMIT 1", ... 阅读全文

posted @ 2014-09-17 13:19 xachary 阅读(2401) 评论(0) 推荐(0) 编辑

根据字段名称查找所在的表名

摘要：SQL ServerSELECT nameFROM sys.sysobjects SOWHERE EXISTS( SELECT * FROM syscolumns SC WHERE name LIKE 'Reason' AND SC.id = SO.id)MySQ... 阅读全文

posted @ 2014-07-21 14:32 xachary 阅读(176) 评论(0) 推荐(0) 编辑