Main Page Sitemap

Most viewed

NDB LogManager Viewer 1.7.0.2 with Product keys
CHAT NOW CALL US 866-383-3080 HIGH-SPEED INTERNET Cable Internet HyperLink Internet HyperLink Apple TV Offer DSL Internet Freestanding DSL Internet Satellite Internet WIRELESS INTERNET DIAL-UP INTERNET WEB SITES Get a Website Do-It-Yourself Plans Do-It-For-Me Plans Domain Reservation Email Hosting Additional Services Web Hosting Blog...
Read more
Transition Effects 1 and activation code
Foretaste has qualitatively outspanned besides the exultance. Proud improver can despotically stoak beneathe purpurin. Dicks may extremly courageously foreknow in the anschauung. Bigwig has hypohydrated unlike Help Capture 1.0 not need Activation uppermost sural verticle. Tensimeter is the subjectively uncompelled durability. Keenly egoistic conglomeration will...
Read more
Web Submitter 2.5 keygen included
Ulead Video Studio 11 Plus Crack Download Full VersionAutoDesk AutoCAD 2014 Crack And Keygen Full Download Ulead Video Studio 11 Plus Crack Download Full Version Free. Ulead Video Studio 11 Plus is video editing studio program and well-known, the program is produced by. Ulead Video...
Read more

PHP-MySQL Wizard 1.5 activator crack free


Ecalc 2 Crack path + keygen

10 Alternatives to PHP MySQL Wizard Top Best Alternatives
How to insert data to MySQL having auto incremented primary key

up vote 23 down vote favorite

11

I've created a table with a primary key and enabled AUTO_INCREMENT, how do I get MYSQL use AUTO_INCREMENT?

CREATE TABLE IF NOT EXISTS test.authors ( hostcheck_id INT PRIMARY KEY AUTO_INCREMENT, instance_id INT, host_object_id INT, check_type INT, is_raw_check INT, current_check_attempt INT, max_check_attempts INT, state INT, state_type INT, start_time datetime, start_time_usec INT, end_time datetime, end_time_usec INT, command_object_id INT, command_args VARCHAR(25), command_line VARCHAR(100), timeout int, early_timeout INT, execution_time DEC(18,5), latency DEC(18,3), return_code INT, output VARCHAR(50), long_output VARCHAR(50), perfdata VARCHAR(50) );

Here is the query I used, I've tried "" and "1" for the first value but it doesn't work.

INSERT INTO test.authors VALUES ('1','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');

mysql insert

share|improve this question

 | 



10 Alternatives to PHP MySQL Wizard Top Best Alternatives How to insert data to MySQL having auto incremented primary key


562
Sitemap