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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZHEN QINGWEI, WANG JIAN, XU RUI, ZHANG LEI, ZHOU FUKE
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
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