https://blog.youkuaiyun.com/j3smilezh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/j3smile/article/details/19990343https://blog.youkuaiyun.com/j3smile/article/details/19990343j3smileWed, 26 Feb 2014 17:57:56 +08000 then created else null end) as trade_created, sum(trade_tidc]]>https://blog.youkuaiyun.com/j3smile/article/details/19988537https://blog.youkuaiyun.com/j3smile/article/details/19988537j3smileWed, 26 Feb 2014 17:00:23 +0800https://blog.youkuaiyun.com/j3smile/article/details/19824965https://blog.youkuaiyun.com/j3smile/article/details/19824965j3smileMon, 24 Feb 2014 15:22:44 +0800https://blog.youkuaiyun.com/j3smile/article/details/19344513https://blog.youkuaiyun.com/j3smile/article/details/19344513j3smileMon, 17 Feb 2014 17:40:43 +0800https://blog.youkuaiyun.com/j3smile/article/details/19340253https://blog.youkuaiyun.com/j3smile/article/details/19340253j3smileMon, 17 Feb 2014 16:34:39 +0800https://blog.youkuaiyun.com/j3smile/article/details/19327067https://blog.youkuaiyun.com/j3smile/article/details/19327067j3smileMon, 17 Feb 2014 10:25:17 +0800https://blog.youkuaiyun.com/j3smile/article/details/19198975https://blog.youkuaiyun.com/j3smile/article/details/19198975j3smileFri, 14 Feb 2014 14:18:37 +0800https://blog.youkuaiyun.com/j3smile/article/details/19194857https://blog.youkuaiyun.com/j3smile/article/details/19194857j3smileFri, 14 Feb 2014 11:30:34 +0800https://blog.youkuaiyun.com/j3smile/article/details/19154309https://blog.youkuaiyun.com/j3smile/article/details/19154309j3smileThu, 13 Feb 2014 10:56:53 +0800 select * from test_1;                             OK 1 1 NULL 2 Time taken: 0.064 seconds select count(distinct id) from test_1; 2]]>https://blog.youkuaiyun.com/j3smile/article/details/18082379https://blog.youkuaiyun.com/j3smile/article/details/18082379j3smileFri, 10 Jan 2014 16:13:09 +0800https://blog.youkuaiyun.com/j3smile/article/details/18001815https://blog.youkuaiyun.com/j3smile/article/details/18001815j3smileWed, 08 Jan 2014 15:30:03 +0800 SELECT something FROM table  WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) select DAY]]>https://blog.youkuaiyun.com/j3smile/article/details/17716823https://blog.youkuaiyun.com/j3smile/article/details/17716823j3smileFri, 03 Jan 2014 16:23:14 +0800https://blog.youkuaiyun.com/j3smile/article/details/17680557https://blog.youkuaiyun.com/j3smile/article/details/17680557j3smileMon, 30 Dec 2013 16:11:54 +0800https://blog.youkuaiyun.com/j3smile/article/details/17302209https://blog.youkuaiyun.com/j3smile/article/details/17302209j3smileFri, 13 Dec 2013 14:53:44 +0800>>>> 建表 create table mytable (   person varchar(10),   `group` int,   age int ); insert into mytable values ('Bob', 1, 32), ('Jill', 1, 34), ('Shawn', 1, ]]>https://blog.youkuaiyun.com/j3smile/article/details/17185851https://blog.youkuaiyun.com/j3smile/article/details/17185851j3smileSat, 07 Dec 2013 13:26:30 +0800https://blog.youkuaiyun.com/j3smile/article/details/17185029https://blog.youkuaiyun.com/j3smile/article/details/17185029j3smileSat, 07 Dec 2013 10:17:29 +0800https://blog.youkuaiyun.com/j3smile/article/details/17101953https://blog.youkuaiyun.com/j3smile/article/details/17101953j3smileTue, 03 Dec 2013 21:44:27 +0800https://blog.youkuaiyun.com/j3smile/article/details/17101827https://blog.youkuaiyun.com/j3smile/article/details/17101827j3smileTue, 03 Dec 2013 21:33:40 +0800https://blog.youkuaiyun.com/j3smile/article/details/17096989https://blog.youkuaiyun.com/j3smile/article/details/17096989j3smileTue, 03 Dec 2013 15:55:16 +0800https://blog.youkuaiyun.com/j3smile/article/details/17077733https://blog.youkuaiyun.com/j3smile/article/details/17077733j3smileMon, 02 Dec 2013 18:34:21 +0800“冻结窗格” =====]]>