0
lee
6 years ago 回复了 CentOS 怎样安装crontab

yum -y install vixie-cron

0
lee
6 years ago 回复了 MySQL数据库里面怎样按1.2.1这种app version版本进行排序

拆分为不同的字段然后就行排序即可

SELECT Version
FROM foo
order by 
SUBSTRING_INDEX( `version` , '.', 1 )*1,
SUBSTRING_INDEX(SUBSTRING_INDEX( `version` , '.', 2 ),'.',-1)*1, 
SUBSTRING_INDEX(SUBSTRING_INDEX( `version` , '.', -2 ),'.',1)*1,
SUBSTRING_INDEX( `version` , '.', -1 )*1

Broadcast


JoyK
Better personal homepage
reddit style
GitHub Flavored Markdown syntax
Adaptive layout