君君的专栏

时间戳方式按照小时分组Select count(*) as count,date_format(FROM_UNIXTIME(createtime),’%Y-%m-%d %H’) as createdate from xtable group by createdate按照天分组Select count(*) as count,date_format(FROM_UNIXTIME(createtime

修改mysql配置文件/etc/my.cnf，在[mysqld] 下增加一行：[mysqld] skip-grant-tables保存并重启mysqlservice mysqld restart登录mysql，无密码，直接回车mysql -uroot -p选择数据库use mysql;修改密码：update user set password=password('root') where user=