Main Page Sitemap

Most viewed

Postal & Intelligent Mail Barcode 2.1.1 with serial number
Firstly, apologies in advance if this is a bit lengthy… Before I give up on my version I felt I ought to check with the more knowledgeable people on here that my version of Easy CD Creator is unlikely to work again. Little background...
Read more
Collins English-German iPhrasefinder for iPod 1 Activator free crack incl
2 - Serials keys - unlocks the world HP PCs - Finding the System Serial Number on Your Computer We are sorry but your search produced 0 results. Please try the following: Use a different search string If search was based on document ID, check...
Read more
DazzleDesign Contacts 1.0.0.0 lifetime activation free
+ From Stellar Information Technology: Stellar MBOX to PST Converter is an easy-to-use e-mail migration tool that converts MBOX files of Thunderbird, Spicebird, Entourage, Pocomail, Eudora, MacLive-mail, Mulberry, OperaMail, SeaMonkey, MozillaMail, Netscape, Evolution, Sylpheed, ClawsMail, Cone, Mutt files and Gnu Mail files to '.PST'...
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