Table expansion method and device of database, storage medium and electronic equipment
The invention discloses a database table expansion method and device, a storage medium and electronic equipment. The method comprises the steps of obtaining a first data table to be subjected to table expansion and a target data table structure; creating a second data table based on the target data...
Gespeichert in:
Hauptverfasser: | , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The invention discloses a database table expansion method and device, a storage medium and electronic equipment. The method comprises the steps of obtaining a first data table to be subjected to table expansion and a target data table structure; creating a second data table based on the target data table structure, the second data table being an empty table; multiple types of triggers are created in the second data table, and the triggers are used for executing preset operation when triggering conditions are met; receiving an expansion instruction, and copying the data of the first data table into the second data table in response to the expansion instruction; detecting a predetermined operation executed by the trigger in the data copying process; and updating the second data table according to a first execution result of the expansion instruction and a predetermined operation executed by the trigger. According to the method and the device, the technical problems that online business operation is blocked and |
---|