01 2012 档案
摘要:这是一个真实的场景,表的定义如下:CREATE TABLE `user` ( `id` bigint(20) NOT NULL, `user_nick` varchar(32), `user_source` tinyint(4) NOT NULL , `user_type` tinyint(4) NOT NULL,........ `version` int(11) DEFAULT '0' COMMENT '版本', `crc_user_nick` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_use
阅读全文
摘要:今天接到报警,报警的信息是:MYSQL_BIN_LOG::purge_logs was called with file '/home/log/mysql-bin.22.log' not listed in the indexgoogle一把,查到了mysql的源码:View Code int MYSQL_BIN_LOG::purge_logs(const char *to_log, bool included, bool need_mutex, ...
阅读全文
摘要:平时工作中有关char,varchar的疑问,今天总结下:char的范围可以存放0到255个字符,注意哦,是确切的字符,CREATE TABLE `t1` ( `id` int(11) DEFAULT NULL, `a` char(255) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=gbk1 row in set (0.00 sec)向表中插入几个值,insert into t1 values(1,'aaaaa'),(2,'我是谁'),(3,'(当我睁开眼睛,发现自己竟然什么也看不见,眼前一片黑暗时,我像被噩
阅读全文