Mysql常见错误
错误1
create table mydatabase.statistics(
id int(10) primary key not null auto_increment,
teleNumber varchar(15) not null,
yearMonth varchar(10) not null,
callDuration int(10) not null)
insert into mydatabase.statistics(teleNumber,yearMonth,callDuration)
values('18907263863','201802',343);
尽管id为自增主键,但是如果在插入语句时,未使用指定字段,则会出错!
insert into mydatabase.statistics values('18907263863','201802',343);