Sqlit Database Upgrade When Android app version is upgraded

When the application version upgrade to do some sqlit operation, such as adding a field, then the version upgrade after the Sqlit does not update will inevitably error

Then Sqlit provides the alert Table command, which allows the user to rename or add fields to the table

Specific solutions (take the table to add fields as an example):

1. Change table name A to temporary table temp_a: 

  

2. Create a new table A with the same original indication (the field in the new table has been incremented) 

  

3. Imports data from temp_a into a new table a" "to supplement a previously nonexistent field 

  

4. Delete temp_a table 

  

Reference: <a target=_blank href= "http://87426628.blog.163.com/blog/static/6069361820131069485844/" >http:// 87426628.blog.163.com/blog/static/6069361820131069485844/</a>

Sqlit Database Upgrade When Android app version is upgraded