Title: WordPress Database Analysis
Last modified: August 19, 2016

---

# WordPress Database Analysis

 *  749457
 * [17 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-analysis/)
 * Hi
 * I was analysing the WordPress database and was trying to “add” posts and categories
   into the database directly without having to go through the interface (I was 
   doing this because I needed to dump a large number of data in wordpress directly)
 * Can you please tell me what do these columns do? I havent been able to figure
   out their functions!.
 * 1. wp_posts table: **“post_name” column** This seems to be permalinks function
   in my opinion. But I havent been able to figure out how to create this manually?
   I mean, what kind of a function does wordpress use to create the “post_name” 
   data?
 * 2. wp_posts table: **guid column** This seems to be some kind of an identifier
   for the posts. But I fail to understand its importance because even if i leave
   this blank, then also the blog seems to work fine.
 * Thanks for taking the time to answer my questions.

The topic ‘WordPress Database Analysis’ is closed to new replies.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 0 replies
 * 1 participant
 * Last reply from: 749457
 * Last activity: [17 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-analysis/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics