这篇文章给大家介绍怎么在Mysql中动态更新数据库，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

动态删除索引

DROPPROCEDUREIFEXISTSUPGRADE;DELIMITER$$CREATEPROCEDUREUPGRADE()BEGIN--RESOURCE.AUDIO_ATTRIBUTEIFEXISTS(SELECT*FROMINFORMATION_SCHEMA.STATISTICSWHERETABLE_SCHEMA='RESOURCE'ANDTABLE_NAME='AUDIO_ATTRIBUTE'ANDINDEX_NAME='resource_publish_resource_id_index')THENALTERTABLE`AUDIO_ATTRIBUTE`DROPINDEXresource_publish_resource_id_index;ENDIF;END$$DELIMITER;CALLUPGRADE();DROPPROCEDUREIFEXISTSUPGRADE;

动态添加字段

DROPPROCEDUREIFEXISTSUPGRADE;DELIMITER$$CREATEPROCEDUREUPGRADE()BEGIN--HOMEWORK.HOMEWORK_QUESTION_GROUP.FROM_IDIFNOTEXISTS(SELECT*FROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA='HOMEWORK'ANDTABLE_NAME='HOMEWORK_QUESTION_GROUP'ANDCOLUMN_NAME='FROM_ID')THENALTERTABLE`HOMEWORK_QUESTION_GROUP`ADDCOLUMNFROM_IDVARCHAR(50)NULL;ENDIF;--HOMEWORK.HOMEWORK_QUESTION_GROUP.QUESTION_TYPEIFNOTEXISTS(SELECT*FROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA='HOMEWORK'ANDTABLE_NAME='HOMEWORK_QUESTION_GROUP'ANDCOLUMN_NAME='QUESTION_TYPE')THENALTERTABLE`HOMEWORK_QUESTION_GROUP`ADDCOLUMNQUESTION_TYPEVARCHAR(50)NULL;ENDIF;--HOMEWORK.HOMEWORK_QUESTION_GROUP.DIFFICULTYIFNOTEXISTS(SELECT*FROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA='HOMEWORK'ANDTABLE_NAME='HOMEWORK_QUESTION_GROUP'ANDCOLUMN_NAME='DIFFICULTY')THENALTERTABLE`HOMEWORK_QUESTION_GROUP`ADDCOLUMNDIFFICULTYVARCHAR(50)NULL;ENDIF;END$$DELIMITER;CALLUPGRADE();DROPPROCEDUREIFEXISTSUPGRADE;

关于怎么在Mysql中动态更新数据库就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。