为了利用列的自动递增功能，在插入行时不要为该列提供值。数据库将为您提供一个值。
INSERT INTO test.authors ( instance_id,host_object_id,check_type,is_raw_check, current_check_attempt,max_check_attempts,state,state_type, start_time,start_time_usec,end_time,end_time_usec,command_object_id, command_args,command_line,timeout,early_timeout,execution_time, latency,return_pre,output,long_output,perfdata) VALUES ( '1','67','0','0','1','10','0','1','2012-01-03 12:50:49','108929', '2012-01-03 12:50:59','198963','21','', '/usr/local/nagios/libexec/check_ping 5','30','0','4.04159', '0.102','1','PING WARNING -DUPLICATES FOUND! Packet loss = 0%, RTA = 2.86 ms', '','rta=2.860000m=0%;80;100;0');
