Inana_的博客

搞了一天，订单按照年月周日分组查询统计，没有的补0。主要两点1：获取完整时间列表SELECT DATE_FORMAT( CURDATE() - INTERVAL ( a.n + ( 10 * b.n )) WEEK, '%Y%u' ) AS date FROM ( SELECT 0 AS n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL S

Mysql对自增主键ID重新排序平时Mysql表维护中，发现有些表例如配置表，自增ID会不断扩大同时不连续，需要重新排列不需要删除数据删除id，并重新创建ALTER TABLE `table_name` DROP `id`;ALTER TABLE `table_name` ADD 'id' mediumint(6) PRIMARY KEY NOT NULL AUTO_INCREMENT FIRST;清空数据删除id，并重新创建truncate table table_name;

比较实用的时期查询SQL语句。假设数据库表中时间字段为add_time，类型为datetime。1.查询当天SELECT * FROM `article` WHERE to_days(`add_time`) = to_days(now());2.查询昨天SELECT * FROM `article` WHERE to_days(now()) – to_days(`add_time`)...

创建/home/mysql_dump目录创建mysql_back.sh文件配置数据库信息写在crontab定时任务#!/bin/sh#File: /home/mysql_dump/mysql_back.sh#Database infoDB_NAME=""DB_USER=""DB_PASS=""# Others vars# whereis mysqldump# IS ` bu...