imsjw

mysql Java tinyint(1) Boolean bigint Long text String

硬盘已满 Disk is full writing mysql8 默认开启binlog 数据库访问量过大 导致日志文件沾满硬盘 最终导致redis服务器崩溃 mysql无法访问 等等情况 出现如下错误 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that sho...

创建表 主键自动增长 id int primary key auto_increment comment '唯一标识符' 创建表时添加外键 跟随删除和修改 foreign key (userId) references user(id) on delete cascade on update cascade 双主键 primary key (userId,taskId) 创建表 creat...

做微信时发现用户昵称中有emoji 字符 导致数据库插入时出现问题 异常信息 ### Error updating database. Cause: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x92\x97C' for column 'nickName' at row 1 ### The error may involve ...