hyd19931002的博客

获取每日某个时间段的数据(08:00-08:02) select sgfssj_dt from b_jtsg_sg where DATE_FORMAT(sgfssj_dt,'%H:%i') >'08:00' and DATE_FORMAT(sgfssj_dt,'%H:%i') <='08:02' LIMIT 1,10

SELECT CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '01' ) hours UNION ALL SELECT CONCAT( SUBSTRING( '2009-01-01 00:00:00', 1, 5 ), '02' ) ...

SELECT ADDDATE(y.first, x.d - 1) as d FROM ( SELECT 1 AS d UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION AL...

原登录:mysql -u root -p; 报以上错误; 改为mysql -h 127.0.0.1 -u root -p; 输入密码,登录问题解决: 哭了:刚刚这种办法解决了,过了5分钟,又报这个错,我真是日了狗; 引用: localhost和127.0.0.1，前者是域名，后者是IP地址中特殊的一类回还地址。 许多时候localhost和127.0.0.1给人感觉...