create table PetDiary(
diary_id int(6) not null AUTO_INCREMENT,
diary_pet_id int(6) not null,
diary_date datetime,
diary_title varchar(40),
diary_weather varchar(30) default '晴',
diary_content varchar(4000),
diary_id_public varchar(5),
diary_las_modify datetime,
diary_author varchar(30) default 'null',
diary_author_email varchar(200) default'null',
primary key (diary_id)
)AUTO_INCREMENT = 1怎么插入数据
insert into PetDiary values('1','2010-07-03 01:04:05','w','ww','kk','off','2010-07-03 01:04:05','kk','kk')如果不写自增字段提示字段和值数量不匹配……
怎么写啊 方便的话写段代码呗!