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里的求平均数 并保留小数点
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
phpMyAdmin 3.4.0 is released
phpMyAdmin 3.4.0 发布了
phpMyAdmi是一个mysql的客户端工具,用php语言编写,免费,开源,功能强大,安装方便,几乎所有的phper和mysql的用户都在使用它,
配合apache能够很轻松的搭建开发环境
用户设置方面的改进
可导出多种格式的数据库结构
枚举/集合的编辑器；
简化数据导入导出界面
AJAXification of some parts
图表改进
可视化查询构建器
原文链接phpMyAdmin 3.4.0 is released
新特性:
* User preferences
* Relation schema export to multiple formats
* ENUM/SET editor
* Simplified interface for export/import
* AJAXification of some parts
* Charts
* Visual query builder