Title: Basic SQL help/strategy needed
Last modified: August 21, 2016

---

# Basic SQL help/strategy needed

 *  [pschnetz](https://wordpress.org/support/users/pschnetz/)
 * (@pschnetz)
 * [13 years ago](https://wordpress.org/support/topic/basic-sql-helpstrategy-needed/)
 * I have just uploaded a 40MB non-wp sql database with thousands of records. I 
   want each record to become its own post. The database I uploaded has 5 related
   tables (but I will only be using 2).
    How do I use fields from my new uploaded
   data as post_title, post_content, tags and so on? Do I have to update the existing
   post_title field with data from my new table? But if I do that then what happens
   to all the related data from the other new tables?
 * Here’s the breakdown: NEW TABLE: (field1, field2…)
    1) AUTHOR: (id, first_initial,
   last_initial, name) 2) QUOTE: (id, author_id, quote, topic, keywords)
 * I would like to use the author name as my post_title and the actual quote as 
   the post_content and the keywords as the tags.
 * I just don’t know how to map the fields over without them losing their ID connection
   that relates them to each other (if I populate post_title with my author name
   field how will it stay connected to the actual quote which is in a different 
   table….do I have to bring over the ID field as well?). Am I going about this 
   entirely wrong?
 * I appreciate any and all help, thanks!!

The topic ‘Basic SQL help/strategy needed’ is closed to new replies.

## Tags

 * [custom fields](https://wordpress.org/support/topic-tag/custom-fields/)
 * [database import](https://wordpress.org/support/topic-tag/database-import/)
 * [post_title](https://wordpress.org/support/topic-tag/post_title/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [pschnetz](https://wordpress.org/support/users/pschnetz/)
 * Last activity: [13 years ago](https://wordpress.org/support/topic/basic-sql-helpstrategy-needed/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics