MySQL-Invalid default value for 建表时设置自增长不能设置默认值，默认值和自增长两者去其一

设置自增不能设置默认值，默认值和自增长两者去其一即可解决。

-------------------------------------------------------------------------------------

尽量采用bigint，bigint的话一般用不完：

https://blog.youkuaiyun.com/qq_35393693/article/details/100059966?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160705086919215668839796%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=160705086919215668839796&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~baidu_landing_v2~default-5-100059966.pc_first_rank_v2_rank_v28&utm_term=mysql%E8%87%AA%E5%A2%9E%E9%95%BF&spm=1018.2118.3001.4449

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

设置自增默认值：从1000开始，但是sqlyog工具并不显示，测试，insert一条数据，从1000开始了，OK。

CREATE TABLE `t_comm_car_number` (
  `sno` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '记录编号',
  `carnumber` VARCHAR(30) NOT NULL COMMENT '车牌号码',
  `ownername` VARCHAR(100) DEFAULT NULL COMMENT '车主姓名',
  `descp` VARCHAR(200) DEFAULT NULL COMMENT '车辆详情说明',
  `state` INT(10) DEFAULT '0' COMMENT '车牌状态,0-有效；1-无效；',
  `flag` INT(10) DEFAULT '0' COMMENT '类别,0--社区车辆；1--外来车辆；2--预留；',
  `projectid` VARCHAR(100) DEFAULT NULL COMMENT '归属项目',
  `remark` VARCHAR(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`sno`),
  UNIQUE KEY `idx_carnumber` (`carnumber`),
  KEY `idx_projectid` (`projectid`)
) ENGINE=INNODB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;

INSERT INTO combodb.t_comm_car_number 
	(sno, 
	carnumber, 
	ownername, 
	descp, 
	state, 
	flag, 
	projectid, 
	remark
	)
	VALUES
	('', 
	'1', 
	'1', 
	'1', 
	'1', 
	'1', 
	'1', 
	'1'
	);

https://blog.youkuaiyun.com/weixin_43526899/article/details/107041553?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160705086919724827651303%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=160705086919724827651303&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_v2~rank_v28-22-107041553.pc_first_rank_v2_rank_v28&utm_term=mysql%E8%87%AA%E5%A2%9E%E9%95%BF&spm=1018.2118.3001.4449