Title: Auto Increment in Managed WordPress
Last modified: January 22, 2020

---

# Auto Increment in Managed WordPress

 *  Resolved [mitrawings](https://wordpress.org/support/users/mitrawings/)
 * (@mitrawings)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/auto-increment-in-managed-wordpress/)
 * Hello, Peter!
    I’ve started using your plugin and must say it fulfills my purpose
   better than other available options. Now, let me come to the point.
 * I’m using the plugin in a managed WordPress hence do not have FTP access. I need
   to include the auto-increment option in tables as the primary key. I have figured
   out how to convert a column into a primary key but have not been able to find
   out how to use the auto-increment option. Kindly help.
 * Also, it would be great if I can use characters followed by incrementing numbers
   as the primary key. That looks cool.
 * For example:
    Simple auto-increment keys are like- 1, 2, 3… And I want- uid1,
   uid2, uid3…
 * Your assistance would really work.
    Thanks a lot!

Viewing 1 replies (of 1 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/auto-increment-in-managed-wordpress/#post-12352794)
 * Hi Mitra,
 * To make a column auto-increment, just enter auto-increment into column Extra 
   in the Data Designer. Sorry, this should be documented…
 * If you have some SQL knowledge, you can also write a create table script and 
   execute your script from the Data Explorer (button import data/execute scrip(
   s).
 * Hope this helps!
 * Best regards,
    Peter

Viewing 1 replies (of 1 total)

The topic ‘Auto Increment in Managed WordPress’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [auto-increment](https://wordpress.org/support/topic-tag/auto-increment/)
 * [primary key](https://wordpress.org/support/topic-tag/primary-key/)

 * 1 reply
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/auto-increment-in-managed-wordpress/#post-12352794)
 * Status: resolved