https://blog.youkuaiyun.com/Maikilee_syszh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/Maikilee_sys/article/details/54863664https://blog.youkuaiyun.com/Maikilee_sys/article/details/54863664Maikilee_sysSat, 04 Feb 2017 16:09:48 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/54847189https://blog.youkuaiyun.com/Maikilee_sys/article/details/54847189Maikilee_sysFri, 03 Feb 2017 16:44:46 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/54836321https://blog.youkuaiyun.com/Maikilee_sys/article/details/54836321Maikilee_sysFri, 03 Feb 2017 14:29:39 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/51690655https://blog.youkuaiyun.com/Maikilee_sys/article/details/51690655Maikilee_sysFri, 21 Oct 2016 10:21:02 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52798581https://blog.youkuaiyun.com/Maikilee_sys/article/details/52798581Maikilee_sysWed, 12 Oct 2016 17:01:30 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52692409https://blog.youkuaiyun.com/Maikilee_sys/article/details/52692409Maikilee_sysWed, 12 Oct 2016 16:55:26 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52689195https://blog.youkuaiyun.com/Maikilee_sys/article/details/52689195Maikilee_sysWed, 28 Sep 2016 11:52:03 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52649826https://blog.youkuaiyun.com/Maikilee_sys/article/details/52649826Maikilee_sysSat, 24 Sep 2016 12:30:44 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52649790https://blog.youkuaiyun.com/Maikilee_sys/article/details/52649790Maikilee_sysSat, 24 Sep 2016 12:18:27 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52640781https://blog.youkuaiyun.com/Maikilee_sys/article/details/52640781Maikilee_sysSat, 24 Sep 2016 11:56:26 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52639483https://blog.youkuaiyun.com/Maikilee_sys/article/details/52639483Maikilee_sysFri, 23 Sep 2016 17:20:11 +0800 select version(); +------------+ | version() | +------------+ | 5.6.31-log | +------------+ 1 row in set (0.00 sec) 提交读查看当前数据库隔离级别mysql> select @@global.tx_isolation,@@tx_isolation; +--------]]>https://blog.youkuaiyun.com/Maikilee_sys/article/details/52625050https://blog.youkuaiyun.com/Maikilee_sys/article/details/52625050Maikilee_sysFri, 23 Sep 2016 11:39:47 +0800 show character set; +----------+-----------------------------+---------------------+--------+ | Charset | Description | Default collation | Maxlen | +----------+--]]>https://blog.youkuaiyun.com/Maikilee_sys/article/details/52624802https://blog.youkuaiyun.com/Maikilee_sys/article/details/52624802Maikilee_sysThu, 22 Sep 2016 17:05:02 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52598411https://blog.youkuaiyun.com/Maikilee_sys/article/details/52598411Maikilee_sysWed, 21 Sep 2016 11:59:54 +0800 select concat('a','b','c'),concat('a',null); +---------------------+------------------+ | concat('a','b','c') | concat('a',null) | +---------------------+------------------+ | abc]]>https://blog.youkuaiyun.com/Maikilee_sys/article/details/52589674https://blog.youkuaiyun.com/Maikilee_sys/article/details/52589674Maikilee_sysTue, 20 Sep 2016 15:18:33 +0800 select version(); +------------+ | version() | +------------+ | 5.6.27-log | +------------+ 1 row in set (0.01 sec) 数值类型 整数类型创建测试表t1mysql> create table t1 (id1 int, in2 int(5)); Que]]>https://blog.youkuaiyun.com/Maikilee_sys/article/details/52527577https://blog.youkuaiyun.com/Maikilee_sys/article/details/52527577Maikilee_sysTue, 13 Sep 2016 17:05:43 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52526541https://blog.youkuaiyun.com/Maikilee_sys/article/details/52526541Maikilee_sysTue, 13 Sep 2016 15:46:02 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52524637https://blog.youkuaiyun.com/Maikilee_sys/article/details/52524637Maikilee_sysTue, 13 Sep 2016 14:07:49 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52512196https://blog.youkuaiyun.com/Maikilee_sys/article/details/52512196Maikilee_sysMon, 12 Sep 2016 15:20:23 +0800https://blog.youkuaiyun.com/Maikilee_sys/article/details/52319105https://blog.youkuaiyun.com/Maikilee_sys/article/details/52319105Maikilee_sysFri, 26 Aug 2016 14:49:00 +0800 create database miles]]>