Basic SQL help/strategy 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.