摘要:
在使用mysql时候,某些字段会存储中文字符,或是包含中文字符的串,查询出来的方法是: SELECT col FROM table WHERE length(col)!=char_length(col) 网上搜索有很多种查询方法,但是试了很多都不行,这个是找到的可以使用的查询方法,原理其实很简单,当 阅读全文
摘要:
UPDATE user_online_month_atu a INNER JOIN ( SELECT user_id, sum(c.online_times) as online_times, SUM(c.login_count) as login_count, Sum(c.view_page_count) as view_page_count, LEFT(c.log_date,length(c... 阅读全文
摘要:
SELECT A.* FROM comm_department A INNER JOIN ( select path,count(*) as count from comm_department group by path having count>1 ) B ON B.path=A.path WHERE EXISTS(SELECT * FROM comm_department C WHER... 阅读全文