{"id":4211715,"date":"2013-10-11T13:01:39","date_gmt":"2013-10-11T13:01:39","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/wordpress-sql-insert-question\/"},"modified":"2016-08-21T05:58:40","modified_gmt":"2016-08-21T05:58:40","slug":"wordpress-sql-insert-question","status":"closed","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/wordpress-sql-insert-question\/","title":{"rendered":"wordpress SQL INSERT Question"},"content":{"rendered":"<p>I am trying to insert in a wp table that has 17 columns.  Does anyone have any thoughts on how to do this more efficiently?  I\u2019d like to incorporate wpdb-&gt;get_col_info(\u2018name\u2019, offset) into this insert statement so I do not have to type them all out.<\/p>\n<p>Thoughts?<\/p>\n<p>$wpdb-&gt;query( $wpdb-&gt;prepare(&#8220;INSERT INTO $wpdb-&gt;mytable (column1, column2, column3, column4, column5, column6, column7, column8, etc etc)<br \/>\n\t\tVALUES ( %d, %s, %s, %s, %s, %s, %s, %s, etc etc )\u201d,<br \/>\n\t$value1, $value1, $value1, $value1, $value1, $value1, $value1, $value1, etc etc) );<\/p>\n","protected":false},"template":"","class_list":["post-4211715","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4211715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4211715\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4211715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}