mysql 错误解决一例 (145) Table ‘common_credit_rule_log’ is marked as crashed and should be repaired
今天论坛突然报错 (145) Table […]
安装mysql时候的Your machine must NOT be named localhost错误
安装mysql时候的Your machine must NOT be named localhost错误
gentoo上安装mysql
emerge –config =dev-db/mysql-5.1.51的时候 出现下面的
Your machine must NOT be named localhost错误
mysql 中的多重排序order by
mysql 中的多重排序order by
主要排序的放前面以此类推,最多可以放16个
SELECT a.* , (a.GROUP_NUM+0) as groupon, (a.UNIT_ID+0) as uniton FROM t_word_group a WHERE BOOK_ID=’1′ order by uniton, groupon
解决mysql migration toolkit 使用中遇到的 initialized java loader error
解决mysql migration toolkit 使用中遇到的 initialized java loader error
mysql里的求平均数 并保留小数点
mysql里的求平均数 并保留小数点
SELECT CAST(AVG( complete_speed ) as decimal(10,2)) as complete_speed,
CAST(AVG( complete_quality ) as decimal(10,2)) as complete_quality ,
CAST(AVG( work_bearing ) as decimal(10,2)) as work_bearing ,
be_marked_user_id , u.first_name , CAST(AVG((complete_speed+complete_quality+work_bearing)/3) as decimal(10,2)) as average
FROM mark_pointresult r left join auth_user u
on u.id=r.be_marked_user_id
GROUP BY be_marked_user_id