Title: WordPress plugin DB upgrade
Last modified: August 22, 2016

---

# WordPress plugin DB upgrade

 *  Resolved [Shailesh](https://wordpress.org/support/users/shaileshsavaliya/)
 * (@shaileshsavaliya)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/wordpress-plugin-db-upgrade/)
 * Hi,
    I am writing plugin. I have added 1 custom table in database.
 * Suppose my plugin’s current version is 1.0
    After few days i am upgrading plugin
   and now its version 1.2. Same for after some time and now version is 1.3 and …..
   1.4
 * Now for every release of plugin version I have made some changes in database.
 * Than how can i upgrade database. I know about store db version in options table.
 * But i don’t know because some user update his plugin from 1.1 -> 1.2, other is
   from 1.1 -> 1.4……… some is 1.2 -> 1.4..etc.. Than there is only way to add all
   conditions to code or any other solution is available?????

Viewing 1 replies (of 1 total)

 *  Thread Starter [Shailesh](https://wordpress.org/support/users/shaileshsavaliya/)
 * (@shaileshsavaliya)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/wordpress-plugin-db-upgrade/#post-5226686)
 * I got the answere
 *     ```
       $db_version = get_option( 'my_plugin_version' );
   
       if ( version_compare( $db_version, '1.1', '<' ) ) {
           // Initial update code added in 1.1
       }
   
       if ( version_compare( $db_version, '1.2', '<' ) ) {
           // Additional update code added in 1.2
       }
   
       if ( version_compare( $db_version, '1.3', '<' ) ) {
           // And so forth
       }
   
       update_option( 'my_plugin_version', '1.3' );
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘WordPress plugin DB upgrade’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [database upgrade](https://wordpress.org/support/topic-tag/database-upgrade/)
 * [plugin database](https://wordpress.org/support/topic-tag/plugin-database/)
 * [upgrade](https://wordpress.org/support/topic-tag/upgrade/)

 * 1 reply
 * 1 participant
 * Last reply from: [Shailesh](https://wordpress.org/support/users/shaileshsavaliya/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/wordpress-plugin-db-upgrade/#post-5226686)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics