CN115617847A - Low-version MYSQL regular replacement method and device - Google Patents
Low-version MYSQL regular replacement method and device Download PDFInfo
- Publication number
- CN115617847A CN115617847A CN202211304313.7A CN202211304313A CN115617847A CN 115617847 A CN115617847 A CN 115617847A CN 202211304313 A CN202211304313 A CN 202211304313A CN 115617847 A CN115617847 A CN 115617847A
- Authority
- CN
- China
- Prior art keywords
- character string
- mysql
- version
- data unit
- character
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The application discloses a low-version MYSQL regular replacement method and device, which can be used in the technical field of artificial intelligence and applied to low-version MYSQL, and the method comprises the following steps: analyzing a character string to be processed by a regular replacement function of the high-version MYSQL to obtain a character string attribute; splitting the character string based on the character string attribute to obtain a minimum data unit; and replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string. According to the method and the device, the characters of the function character string are regularly replaced by the low-version MYSQL to replace the high-version MYSQL, and a regular replacement function is achieved.
Description
Technical Field
The application relates to the technical field of databases, in particular to the technical field of artificial intelligence, and particularly relates to a low-version MYSQL regular replacement method and device.
Background
This section is intended to provide a background or context to the embodiments of the application that are recited in the claims. The description herein is not admitted to be prior art by inclusion in this section.
In actual work, according to the type and version of the database selected by project development, the data processing function provided by the database with high version obviously cannot be used in the database with low version. Such as the canonical replacement function REGEXP _ REPLACE (), which is not used below MYSQL version 8.0.
Disclosure of Invention
One object of the application is to provide a low-version MYSQL regular replacement method, which replaces characters of a high-version MYSQL regular replacement function string with low-version MYSQL to realize a regular replacement function. Another object of the present application is to provide a low version MYSQL canonical replacement device. It is a further object of this application to provide a computer apparatus. It is a further object of the present application to provide a readable medium. It is a further object of this application to provide a computer program product.
In order to achieve the above object, the present application discloses, on one hand, a low version MYSQL regular replacement method, applied to low version MYSQL, comprising:
analyzing a character string to be processed by a regular replacement function of the high-version MYSQL to obtain a character string attribute;
splitting the character string based on the character string attribute to obtain a minimum data unit;
and replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string.
Preferably, the analyzing the character string of the regular replacement function of the high version MYSQL to obtain the character string attribute specifically includes:
and determining the length of the data item of the character string and the data item to be replaced in the regular replacement function of the high-version MYSQL to obtain the attribute of the character string.
Preferably, the splitting the character string based on the character string attribute to obtain the minimum data unit specifically includes:
and splitting the data item to be replaced in the character string attribute to obtain the minimum data unit.
Preferably, the splitting the data item to be replaced in the character string attribute to obtain the minimum data unit specifically includes:
and splitting the data item through a help _ topic _ id of a mysql. Help _ topic table to obtain all minimum data units.
Preferably, the replacing the minimum data unit to obtain the new character specifically includes:
determining whether each minimum data unit is matched with a preset character set;
if yes, replacing the characters of the matched minimum data unit with the characters in the preset character set to obtain a new character corresponding to each minimum data unit;
and if not, taking the character of the minimum data unit as a new character.
The application also discloses regular substitution device of low version MYSQL, is applied to low version MYSQL, the device includes:
the character string analysis module is used for analyzing the character string to be processed of the regular replacement function of the high-version MYSQL to obtain the character string attribute;
the character string splitting module is used for splitting the character string based on the character string attribute to obtain a minimum data unit;
and the character string replacing module is used for replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string.
Preferably, the character string parsing module is specifically configured to determine a data item length of a character string and a data item to be replaced in a canonical replacement function of the high-version MYSQL, and obtain a character string attribute.
Preferably, the character string splitting module is specifically configured to split the data item to be replaced in the character string attribute to obtain a minimum data unit.
Preferably, the string splitting module is specifically configured to split the data item by a help _ topic _ id of a mysql. Help _ topic table to obtain all minimum data units.
Preferably, the character string replacement module is specifically configured to determine whether each minimum data unit matches a preset character set; if yes, replacing the characters of the matched minimum data unit with the characters in the preset character set to obtain a new character corresponding to each minimum data unit; and if not, taking the character of the minimum data unit as a new character.
The application also discloses a computer device, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the method when executing the computer program.
The present application also discloses a computer-readable storage medium storing a computer program which, when executed by a processor, implements the above-described method.
The application also discloses a computer program product comprising a computer program which, when executed by a processor, implements the above method.
The low-version MYSQL regular replacement method is applied to the low-version MYSQL, and the character string attribute is obtained by analyzing the character string to be processed of the regular replacement function of the high-version MYSQL through the low-version MYSQL; splitting the character string based on the character string attribute to obtain a minimum data unit; and replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string. Therefore, the method and the device have the advantages that the character string of the regular replacement function of the high-version MYSQL is split and replaced by the low-version MYSQL to obtain a new character string, and the regular replacement function is achieved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:
FIG. 1 illustrates a flow diagram of a particular embodiment of a low version MYSQL canonical replacement method of the present application;
FIG. 2 shows a flowchart of a specific embodiment S100 of the low version MYSQL canonical replacement method of the present application;
FIG. 3 shows a flowchart of a specific embodiment S200 of the low version MYSQL canonical replacement method of the present application;
FIG. 4 shows a flowchart of a specific embodiment S210 of the low version MYSQL canonical replacement method of the present application;
FIG. 5 shows a flowchart of a specific embodiment S300 of the low version MYSQL canonical replacement method of the present application;
FIG. 6 is a block diagram illustrating a specific embodiment of a low-version MYSQL regular replacement apparatus according to the present application;
FIG. 7 illustrates a schematic block diagram of a computer device suitable for use in implementing embodiments of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described clearly and completely with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
According to the technical scheme, the data acquisition, storage, use, processing and the like meet relevant regulations of national laws and regulations.
It should be noted that the low-version MYSQL regular replacement method and device disclosed by the application can be used in the technical field of artificial intelligence and can also be used in any field except the technical field of artificial intelligence, and the application field of the low-version MYSQL regular replacement method and device disclosed by the application is not limited.
In order to facilitate understanding of the technical solutions provided in the present application, the following first describes relevant contents of the technical solutions in the present application. According to the regular replacement method for the low-version MYSQL, the character string of the regular replacement function of the high-version MYSQL is split through the low-version MYSQL and replaced to obtain a new character string, and the regular replacement function is achieved.
The implementation process of the low-version MYSQL regular replacement method provided in the embodiment of the present application is described below by taking the low-version MYSQL regular replacement device as an execution subject. It can be understood that the execution subject of the low version MYSQL regular replacement method provided by the embodiment of the present application includes, but is not limited to, the low version MYSQL regular replacement device.
According to one aspect of the application, the embodiment discloses a low-version MYSQL regular replacement method, which is applied to low-version MYSQL, wherein the version of the low-version MYSQL is lower than that of high-version MYSQL, and a regular replacement function of the high-version MYSQL does not exist in the low-version MYSQL, so that a regular replacement function cannot be realized. As shown in fig. 1, in this embodiment, the method includes:
s100: and analyzing the character string to be processed by the regular replacement function of the high-version MYSQL to obtain the character string attribute.
S200: and splitting the character string based on the character string attribute to obtain a minimum data unit.
S300: and replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string.
The low-version MYSQL regular replacement method is applied to the low-version MYSQL, and the character string attribute is obtained by analyzing the character string to be processed of the regular replacement function of the high-version MYSQL through the low-version MYSQL; splitting the character string based on the character string attribute to obtain a minimum data unit; and replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string. Therefore, the character string of the regular replacement function of the high-version MYSQL is split and replaced through the low-version MYSQL to obtain a new character string, and the regular replacement function is achieved.
In a preferred embodiment, as shown in fig. 2, the step S100 of performing string parsing on the canonical replacement function of the high version MYSQL to obtain a string attribute specifically includes:
s110: and determining the length of the data item of the character string and the data item to be replaced in the regular replacement function of the high-version MYSQL to obtain the attribute of the character string.
In particular, it will be appreciated that a canonical replacement function (REGEXP _ REPLACE function) in high version MYSQL may be used for pattern matching, i.e., to REPLACE a given string character by a matching character. Specifically, the function is a newly added function of the MYSQL version 8.0, and the MYSQL version lower than 8.0 does not have the regular replacement function. Analyzing the data format of the character string is a starting link of data processing. For the character string of the data set to be replaced, the length of the data item needs to be analyzed, and one or more replaced data items need to be compared for subsequent data splitting and replacement.
In a preferred embodiment, as shown in fig. 3, the splitting the character string based on the character string attribute by the S200 to obtain a minimum data unit specifically includes:
s210: and splitting the data item to be replaced in the character string attribute to obtain the minimum data unit.
Specifically, it can be understood that the composition form of the character string is obtained after the character string attribute is obtained by analyzing the character string in the regular replacement function, so that the data item to be replaced in the character string attribute obtained by analysis can be split to obtain the minimum data unit, and the character string can be split to obtain the character to be replaced.
In a preferred embodiment, as shown in fig. 4, the splitting the data item to be replaced in the character string attribute by S210 to obtain a minimum data unit specifically includes:
s211: splitting the data item through a help _ topic _ id of a mysql. Help _ topic table to obtain all minimum data units.
In the preferred embodiment, a plurality of data items are obtained by splitting a character string in a high-version regular replacement function through a separation symbol, and then each data item is further split to obtain a minimum data unit for comparison and determination of whether replacement is needed, that is, a character that cannot be split again.
The character strings needing to be replaced are split according to separation symbols among data items, and the character strings are split according to characters by help of the help _ topic _ id of the mysql.
An example of an implementation script in low version MYSQL is as follows:
in a preferred embodiment, as shown in fig. 5, the step S300 of replacing the minimum data unit to obtain a new character specifically includes:
s310: it is determined whether each minimum data unit matches a preset character set.
S320: if yes, replacing the characters of the matched minimum data unit with the characters in the preset character set to obtain a new character corresponding to each minimum data unit.
S330: and if not, taking the character of the minimum data unit as a new character.
Specifically, it can be understood that comparing the relationship between the character of the minimum data unit after splitting and the character string to be compared replaces the character that meets the replacement format or requirement. Firstly, judging whether the minimum data unit [ char ] formed by splitting is matched with a replaced character set REGEXP; if matching, replacing with blank, otherwise keeping original character [ char ].
In a specific example, the implementation script is illustrated as follows:
IF(([char]REGEXP
'([^ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz
0123456789():”,+-./？])')＝0,new_temp,”)。
in an optional embodiment, when all new characters are combined to obtain a new character string, the compared and replaced characters [ char ] can be spliced together by the GROUP _ CONCAT () function to obtain the new character string.
If the string C _ INSTR: ' non-AZaz 09 () ' in Chinese character 12a3', + -/? The characters of (2) are replaced with spaces. Then, in the method, the data is first split into 6 single characters [ char ]: 'Chinese', 'character', '1', '2', 'a', '3'; replacing the Chinese characters and the characters with blank spaces; and finally, replacing the [ char ]: "," '1', "2 ', ' a ' and '3' are spliced into a character string '12a3' with a fixed separator. The method comprises the following specific steps:
in a specific example, the implementation script is illustrated as follows:
GROUP_CONCAT([char]SEPARATOR”)。
in a specific example, a non-AZaz 09 ():', + -/? The character of (2) is a space function. In the high version MYSQL supporting the REGEXP _ REPLACE () function, it can be quickly implemented as follows:
in the low version MYSQL that does not support the REGEXP _ REPLACE () function, this can be implemented by the following script:
according to the method, the character strings are split according to characters by means of the help _ topic _ id of the help _ topic table of mysql, and then replacement processing is performed on the split minimum units. The character string is split into characters through help _ topic _ id, whether the characters are matched or not is judged through a matching function REGEXP, and finally, the matched result is aggregated into a new character string. The new character string is consistent with the character string obtained by replacing the character string through the regular replacement function of the high-version MYSQL, namely the character string replacement function of the regular replacement function in the high-version MYSQL is realized in the low-version MYSQL, the problem of low efficiency of data processing of the low-version database is solved, the universality is realized through the standard SQL script, and meanwhile, the method and the device support the realization in different databases.
Based on the same principle, the embodiment of the application also discloses a low-version MYSQL regular replacement device which is applied to the low-version MYSQL. As shown in fig. 6, in this embodiment, the apparatus includes a character string parsing module 11, a character string splitting module 12, and a character string replacing module 13.
The character string analysis module 11 is configured to analyze a character string to be processed by the regular replacement function of the high-version MYSQL to obtain a character string attribute.
The character string splitting module 12 is configured to split the character string based on the character string attribute to obtain a minimum data unit.
The character string replacement module 13 is configured to replace the minimum data unit to obtain a new character, and combine all the new characters to obtain a new character string.
In a preferred embodiment, the character string parsing module 11 is specifically configured to determine a data item length of a character string and a data item to be replaced in a regular replacement function of high-version MYSQL, and obtain a character string attribute.
In a preferred embodiment, the character string splitting module 12 is specifically configured to split the data item to be replaced in the character string attribute to obtain a minimum data unit.
In a preferred embodiment, the character string splitting module 12 is specifically configured to split the data item by using a help _ id of a mysql.
In a preferred embodiment, the character string replacement module 13 is specifically configured to determine whether each minimum data unit matches a preset character set; if yes, replacing the characters of the matched minimum data unit with the characters in the preset character set to obtain a new character corresponding to each minimum data unit; and if not, taking the character of the minimum data unit as a new character.
Since the principle of the device for solving the problems is similar to the method, the implementation of the device can refer to the implementation of the method, and the detailed description is omitted here.
The embodiment of the present application further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the above abnormal transaction real-time detection method when executing the computer program.
An embodiment of the present application further provides a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the method for detecting abnormal transactions in real time is implemented.
The embodiment of the present application further provides a computer program product, the computer program product includes a computer program, and when the computer program is executed by a processor, the method for detecting abnormal transactions in real time is implemented.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. A typical implementation device is a computer device, which may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
In a typical example, the computer device specifically comprises a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the method performed by the client as described above when executing the program, or the processor implementing the method performed by the server as described above when executing the program.
Reference is now made to fig. 7, which illustrates a schematic block diagram of a computer device 600 suitable for use in implementing embodiments of the present application.
As shown in fig. 7, the computer apparatus 600 includes a Central Processing Unit (CPU) 601 that can perform various appropriate jobs and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage section 608 into a Random Access Memory (RAM) 603. In the RAM603, various programs and data necessary for the operation of the system 600 are also stored. The CPU601, ROM602, and RAM603 are connected to each other via a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
The following components are connected to the I/O interface 605: an input portion 606 including a keyboard, a mouse, and the like; an output portion 607 including a Cathode Ray Tube (CRT), a liquid crystal feedback (LCD), and the like, and a speaker and the like; a storage section 608 including a hard disk and the like; and a communication section 609 including a network interface card such as a LAN card, a modem, or the like. The communication section 609 performs communication processing via a network such as the internet. The driver 610 is also connected to the I/O interface 605 as needed. A removable medium 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 610 as necessary, so that a computer program read out therefrom is mounted as necessary on the storage section 608.
In particular, according to embodiments of the application, the processes described above with reference to the flow diagrams may be implemented as computer software programs. For example, embodiments of the present application include a computer program product comprising a computer program tangibly embodied on a machine-readable medium, the computer program comprising program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 609, and/or installed from the removable medium 611.
Computer-readable media, including both permanent and non-permanent, removable and non-removable media, may implement the information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising one of 8230; \8230;" 8230; "does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises that element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and so forth) having computer-usable program code embodied therein.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art to which the present application pertains. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (13)
1. A low-version MYSQL regular replacement method is applied to low-version MYSQL and comprises the following steps:
analyzing a character string to be processed by a regular replacement function of the high-version MYSQL to obtain a character string attribute;
splitting the character string based on the character string attribute to obtain a minimum data unit;
and replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string.
2. The regular replacement method of low-version MYSQL according to claim 1, wherein the analyzing the character string of the regular replacement function of high-version MYSQL to obtain the character string attribute specifically comprises:
and determining the length of the data item of the character string and the data item to be replaced in the regular replacement function of the high-version MYSQL to obtain the attribute of the character string.
3. The low-version MYSQL regular replacement method according to claim 1, wherein the splitting the character string based on the character string attribute to obtain a minimum data unit specifically comprises:
and splitting the data item to be replaced in the character string attribute to obtain the minimum data unit.
4. The low-version MYSQL regular replacement method according to claim 1, wherein the splitting of the data items to be replaced in the character string attributes to obtain the minimum data unit specifically comprises:
and splitting the data item through a help _ topic _ id of a mysql. Help _ topic table to obtain all minimum data units.
5. The low version MYSQL regular replacement method of claim 1, wherein the replacing the minimum data unit to obtain a new character specifically comprises:
determining whether each minimum data unit is matched with a preset character set;
if yes, replacing the characters of the matched minimum data unit with the characters in the preset character set to obtain a new character corresponding to each minimum data unit;
and if not, taking the character of the minimum data unit as a new character.
6. A low-version MYSQL regular replacement device is applied to low-version MYSQL, and comprises the following steps:
the character string analysis module is used for analyzing the character string to be processed by the regular substitution function of the high-version MYSQL to obtain the character string attribute;
the character string splitting module is used for splitting the character string based on the character string attribute to obtain a minimum data unit;
and the character string replacing module is used for replacing the minimum data unit to obtain a new character, and combining all the new characters to obtain a new character string.
7. The regular replacement device of low version MYSQL (MySQL query language) according to claim 6, wherein the character string parsing module is specifically configured to determine the length of a data item of a character string in a regular replacement function of high version MYSQL and a data item to be replaced, and obtain a character string attribute.
8. The low-version MYSQL regular replacement device according to claim 6, wherein the character string splitting module is specifically configured to split a data item to be replaced in the character string attribute to obtain a minimum data unit.
9. The low-version MYSQL regular replacement device according to claim 8, wherein the character string splitting module is specifically configured to split the data items by help _ topic _ id of a MYSQL.
10. The low-version MYSQL regular replacement device according to claim 6, wherein the character string replacement module is specifically configured to determine whether each minimum data unit matches a preset character set; if yes, replacing the characters of the matched minimum data unit with the characters in the preset character set to obtain a new character corresponding to each minimum data unit; and if not, taking the character of the minimum data unit as a new character.
11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any of claims 1 to 5 when executing the computer program.
12. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program which, when executed by a processor, implements the method of any of claims 1 to 5.
13. A computer program product, characterized in that the computer program product comprises a computer program which, when being executed by a processor, carries out the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211304313.7A CN115617847A (en) | 2022-10-24 | 2022-10-24 | Low-version MYSQL regular replacement method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211304313.7A CN115617847A (en) | 2022-10-24 | 2022-10-24 | Low-version MYSQL regular replacement method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115617847A true CN115617847A (en) | 2023-01-17 |
Family
ID=84863730
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211304313.7A Pending CN115617847A (en) | 2022-10-24 | 2022-10-24 | Low-version MYSQL regular replacement method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115617847A (en) |
-
2022
- 2022-10-24 CN CN202211304313.7A patent/CN115617847A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10095780B2 (en) | Automatically mining patterns for rule based data standardization systems | |
| US8442935B2 (en) | Extract, transform and load using metadata | |
| US20190095318A1 (en) | Test-assisted application programming interface (api) learning | |
| CN110858172A (en) | Automatic test code generation method and device | |
| CN110765773A (en) | Address data acquisition method and device | |
| CN111931183A (en) | Open source software security vulnerability processing method and device | |
| CN115358397A (en) | Parallel graph rule mining method and device based on data sampling | |
| CN115757400A (en) | Data table processing method and device, electronic equipment and computer readable medium | |
| CN114398315A (en) | Data storage method, system, storage medium and electronic equipment | |
| US20190026081A1 (en) | Method and device for generating code assistance information | |
| CN113761565B (en) | Data desensitization method and device | |
| CN108694172B (en) | Information output method and device | |
| CN110941655B (en) | Data format conversion method and device | |
| CN115617847A (en) | Low-version MYSQL regular replacement method and device | |
| CN115454971A (en) | Data migration method and device, electronic equipment and storage medium | |
| CN114677125A (en) | Standard data processing method, device and system | |
| CN114547050A (en) | Batch processing content duplication judging method, system, device, terminal equipment and storage medium | |
| CN109739883B (en) | Method and device for improving data query performance and electronic equipment | |
| CN110309315B (en) | Template file generation method and device, computer readable medium and electronic equipment | |
| JP6870454B2 (en) | Analytical equipment, analytical programs and analytical methods | |
| CN112130862B (en) | Method, apparatus, device and computer readable storage medium for generating package file | |
| CN114817929B (en) | Method and device for dynamically tracking and processing vulnerability of Internet of things, electronic equipment and medium | |
| CN110765100B (en) | Label generation method and device, computer readable storage medium and server | |
| CN110941604B (en) | Data storage method and device | |
| CN114584616B (en) | Message pushing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |