mysql
LFF1991
这个作者很懒,什么都没留下…
展开
-
Mysql创建表实现主键自增并且初始值为1000
具体sql语句为如下:CREATE TABLE `seckill` ( `seckill_id` bigint(20) NOT NULL AUTO_INCREMENT comment '商品库存id' , `name` varchar(120) NOT NULL comment '商品名称' , `number` int(11) NOT NULL comment '库存数量', `原创 2017-04-13 23:13:20 · 5575 阅读 · 0 评论 -
Exception:Establishing SSL connection without server's identity verification is not recommended
Exception description(异常描述):Fri Aug 18 09:00:08 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requ原创 2017-08-18 11:07:27 · 762 阅读 · 0 评论 -
mysql连接异常:The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zo
错误信息如下: The server time zone value ‘�й���ʱ��’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property原创 2017-08-15 16:23:53 · 5556 阅读 · 0 评论 -
Exception:Data truncation: Out of range value for column 'phone' at row 1异常问题
今天我在做登陆系统的时候用户手机号字段定义为int 类型并且长度为11结果出现了下列异常:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'phone' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.j原创 2017-09-18 13:04:16 · 5045 阅读 · 0 评论