StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMySQL: Column Count Doesn't Match Value Count
text
Body
copied!<p><em><strong></em> UPDATE **</strong> Thank you for everyone's help. It is appreciated. It was a trigger that was being used, and not an issue with the Insert. I had tunnel visioned on the insert and forgot all about checking the trigger. </p> <hr> <p>I can't for the life of me figure out the problem with this mysql insert:</p> <pre><code>INSERT INTO campaigns (camp_id,camp_name,camp_desc,camp_created,camp_creator,camp_start,camp_end,camp_active) VALUES (null,'Clinic','2013 Clinic',now(),'user','2013-10-21','2013-10-25',1); </code></pre> <p>Table:</p> <pre><code>Field Type Null Key Default Extra =========================================================================================== camp_id int(12) NO PRI auto_increment camp_name varchar(32) NO camp_desc varchar(255) YES camp_created timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP camp_creator varchar(16) NO camp_start date NO camp_end date NO camp_active int(1) NO </code></pre> <p>Any help is appreciated.</p> <p>Per Requests: SHOW CREATE TABLE campaigns:</p> <pre><code>CREATE TABLE `campaigns` ( `camp_id` int(12) NOT NULL AUTO_INCREMENT, `camp_name` varchar(32) NOT NULL, `camp_desc` varchar(255) DEFAULT NULL, `camp_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `camp_creator` varchar(16) NOT NULL, `camp_start` date NOT NULL, `camp_end` date NOT NULL, `camp_active` int(1) NOT NULL, PRIMARY KEY (`camp_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload