Title: SQL database format
Last modified: August 24, 2016

---

# SQL database format

 *  [tpaul25](https://wordpress.org/support/users/tpaul25/)
 * (@tpaul25)
 * [11 years ago](https://wordpress.org/support/topic/sql-database-format/)
 * Love this plugin. However, while I can see the data listed by Field name in Columns
   in the Contact Form to DB area on WordPress, when I go into SQL database into
   the Submit table, the field names are all listed under the “Field_Name” Column.
   I would Like the individual Field Names to be their own columns and the data 
   listed underneath the individual Field Names. How can I get this to happen?
 * ex: I have First Name, Last Name and Age. In the Contact Form DB area in the 
   Admin, I see
    First Name Last Name Age John Smith 50
 * This is what I want.
 * In the SQL database, under the submit table, it’s listed like this:
 * FieldName Value
    First Name John Last Name Smith Age 50
 * How can I make this change?
 * Thanks,
 * Tracy
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [tpaul25](https://wordpress.org/support/users/tpaul25/)
 * (@tpaul25)
 * [11 years ago](https://wordpress.org/support/topic/sql-database-format/#post-6174275)
 * Just to add to this: I know I could do a pivot query but that won’t due as it
   will slow processes down. I want a way for the form submissions to feed directly
   to the database structured above without having to do that query. Any way to 
   do that other than revamping the plugin? (which I am not talented enough to do)
 * Thanks!
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years ago](https://wordpress.org/support/topic/sql-database-format/#post-6174470)
 * If you want to save the data into your own table structure then you would have
   to write code for that.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL database format’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [SQL tables](https://wordpress.org/support/topic-tag/sql-tables/)

 * 2 replies
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [11 years ago](https://wordpress.org/support/topic/sql-database-format/#post-6174470)
 * Status: not resolved