MySQL
「已注销」
每天都在快乐地搬砖
展开
-
MySQL日期函数总结
目录参考链接当前日期当前日期时间日期操作函数参考链接http://wiki.jikexueyuan.com/project/mysql/useful-functions/time-functions.html当前日期函数名称:curdate 查询命令: select curdate(); 命令解释: help curdate; ...原创 2019-05-17 10:25:00 · 288 阅读 · 0 评论 -
MySql事务隔离级别-未提交读(READ UNCOMMITTED)
准备工作DROP TABLE IF EXISTS `t1`;CREATE TABLE `t1` ( `id` int(11) NOT NULL, `num` int(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;执行步骤 SESSION A SESSION...原创 2019-08-04 01:06:39 · 1054 阅读 · 0 评论 -
MySql事务隔离级别-已提交读(READ COMMITTED)
准备工作以及SQL解释参考:https://mp.csdn.net/postedit/98398695执行步骤 SESSION A SESSION B T1 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; T2 START TRANSACTION; T3 ...原创 2019-08-04 11:27:35 · 965 阅读 · 0 评论 -
MySql事务隔离级别-可重复读(REPEATABLE READ)
准备工作以及SQL解释参考:https://mp.csdn.net/postedit/98398695执行步骤 SESSION A SESSION B T1 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; T2 START TRANSACTION; T3 ...原创 2019-08-04 11:38:58 · 340 阅读 · 0 评论 -
MySql事务隔离级别-序列化(SERIALIZABLE)
准备工作以及SQL解释参考:https://mp.csdn.net/postedit/98398695INSERT INTO `t1` VALUES (1, 100);执行步骤 SESSION A SESSION B T1 SET SESSION TRANSACTION ISOLATION LEVELSERIALIZABLE; T2 ST...原创 2019-08-04 12:15:17 · 482 阅读 · 0 评论