ThefFirsttThelLast的博客

-- 开启慢查询日志set global slow_query_log=ON;show variables like "%slow%";-- 查看当前进程show processlist;-- 查看是否锁表show OPEN TABLES where In_use > 0;-- 查看当前的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_TR...

ALTER TABLE tablename ADD COLUMN columnname TIMESTAMP(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0);时间戳格式yyyy-MM-ddhh:mm:ssTIMESTAMP(0)、CURRENT_TIMESTAMP(0)中0代表毫秒级长度，长度范...