Database table changing method and device, computer equipment and storage medium

A database and data table technology, applied in the computer field, can solve problems such as low efficiency of database tables

Pending Publication Date: 2020-07-24
PING AN TECH (SHENZHEN) CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Embodiments of the present invention provide a database table modification method, device, computer equipment, and storage medium to solve the current problem of low efficiency of database table modification execution

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database table changing method and device, computer equipment and storage medium
  • Database table changing method and device, computer equipment and storage medium
  • Database table changing method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0029] The database form change method provided by this application can be applied in such as figure 1 In the shown application environment, the application environment includes a server and a client, wherein the server and the application client are connected through a network, the network may be a wired network or a wireless network, and the client specifically includes but is not limited to various Various personal computers, notebook computers, sma...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a database table changing method and device, computer equipment and a storage medium. The method comprises the steps: acquiring table change information of a database, acquiring first target sub-table information of the database according to the table change information, and enabling the database to be subjected to sub-database sub-table processing; generating a target change statement according to the first target sub-table information and the table change information, wherein the target change statement adopts a data definition language; obtaining a target Internet protocol address according to the first target sub-table information; and executing the target change statement according to the target Internet protocol address so as to complete table change of the database. According to the technical scheme, the DBA can automatically execute table change of the database through one key, the working efficiency is improved, and online faults caused by manual tablechange of the database are reduced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database table modification method, device, computer equipment and storage medium. Background technique [0002] Using sub-database and sub-table in MySQL database can be very convenient for horizontal expansion and improve the processing capacity of the system. However, after sub-database and table division, the tables are divided into tens of thousands of tables and scattered in hundreds of clusters, making it very difficult to change database tables. [0003] At present, when the database table needs to be changed, the usual practice is to provide a set of customized scripts for the sub-database and sub-table, and then execute the database table change by running the script. However, because the basic information such as IP, port, database name, and table name corresponding to each set of sub-databases and sub-tables is different, script writing is prone to errors, operat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/242G06F16/28
CPCG06F16/2282G06F16/2433G06F16/284
Inventor 李亮光
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap