CN115994152A - Verification method, device, equipment and storage medium of MySQL query statement - Google Patents
Verification method, device, equipment and storage medium of MySQL query statement Download PDFInfo
- Publication number
- CN115994152A CN115994152A CN202310294701.XA CN202310294701A CN115994152A CN 115994152 A CN115994152 A CN 115994152A CN 202310294701 A CN202310294701 A CN 202310294701A CN 115994152 A CN115994152 A CN 115994152A
- Authority
- CN
- China
- Prior art keywords
- sub
- query statement
- query
- mysql
- abnormal
- 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
- 238000012795 verification Methods 0.000 title claims abstract description 74
- 238000000034 method Methods 0.000 title claims abstract description 45
- 230000002159 abnormal effect Effects 0.000 claims abstract description 45
- 238000012216 screening Methods 0.000 claims description 27
- 230000005856 abnormality Effects 0.000 claims description 3
- 238000004519 manufacturing process Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 17
- 238000001914 filtration Methods 0.000 description 6
- 230000000694 effects Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- FGUUSXIOTUKUDN-IBGZPJMESA-N C1(=CC=CC=C1)N1C2=C(NC([C@H](C1)NC=1OC(=NN=1)C1=CC=CC=C1)=O)C=CC=C2 Chemical compound C1(=CC=CC=C1)N1C2=C(NC([C@H](C1)NC=1OC(=NN=1)C1=CC=CC=C1)=O)C=CC=C2 FGUUSXIOTUKUDN-IBGZPJMESA-N 0.000 description 1
- YTAHJIFKAKIKAV-XNMGPUDCSA-N [(1R)-3-morpholin-4-yl-1-phenylpropyl] N-[(3S)-2-oxo-5-phenyl-1,3-dihydro-1,4-benzodiazepin-3-yl]carbamate Chemical compound O=C1[C@H](N=C(C2=C(N1)C=CC=C2)C1=CC=CC=C1)NC(O[C@H](CCN1CCOCC1)C1=CC=CC=C1)=O YTAHJIFKAKIKAV-XNMGPUDCSA-N 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013515 script Methods 0.000 description 1
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a verification method, device and equipment for MySQL query sentences and a storage medium, wherein the method comprises the following steps: obtaining MySQL query sentences to be checked, generating a grammar tree according to the MySQL query sentences, wherein the grammar tree characterizes nested relations among query sentences of each layer in the MySQL query sentences divided according to grammar; analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement; and checking whether the sub-query statement is abnormal or not to obtain a checking result. According to the invention, the pre-verification of the MySQL data before the production is put into production is realized by verifying the MySQL query statement, so that the risk of operation hidden danger caused by problem data is avoided; and the verification result has high accuracy.
Description
Technical Field
The embodiment of the invention relates to the technical field of MySQL database application, in particular to a method, a device, equipment and a storage medium for checking MySQL query sentences.
Background
MySQL is a relational database management system that keeps data in different tables rather than placing all data in one large warehouse, increasing speed and flexibility.
Currently, most of verification methods for data in MySQL are post verification methods based on generated data development scripts, for example: zero value checking, cross checking, etc. Post-verification occurs after the data is put into production, so that problem data can cause operational hazards before it is discovered by post-verification.
In addition, the accuracy of the verification result of the existing post-verification method is low.
Disclosure of Invention
The embodiment of the invention provides a method, a device, equipment and a storage medium for checking MySQL query sentences, which are used for solving the problems that the problem data can cause operation hidden danger before being found by post-checking and the accuracy of the checking result of the existing post-checking method is low.
In order to solve the technical problems, the invention is realized as follows:
in a first aspect, an embodiment of the present invention provides a method for checking MySQL query statements, including:
obtaining MySQL query sentences to be checked, generating a grammar tree according to the MySQL query sentences, wherein the grammar tree characterizes nested relations among query sentences of each layer in the MySQL query sentences divided according to grammar;
analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement;
and checking whether the sub-query statement is abnormal or not to obtain a checking result.
Alternatively, the process may be carried out in a single-stage,
checking whether the sub-query statement is abnormal or not to obtain a checking result, including:
constructing a resource tree taking the sub-query statement as a node;
and checking whether each sub-query statement on the resource tree is abnormal or not to obtain the checking result.
Alternatively, the process may be carried out in a single-stage,
checking whether each sub-query statement on the resource tree is abnormal, including:
checking whether the special screening item of the sub-query statement is abnormal or not to obtain a first sub-check result; and checking whether the associated item of the sub-query statement is abnormal or not to obtain a second sub-check result;
and integrating the first sub-verification result and the second sub-verification result to obtain the verification result.
Alternatively, the process may be carried out in a single-stage,
checking whether the special screening item of the sub-query statement is abnormal or not comprises the following steps:
determining a MySQL database to be queried by the MySQL query statement, and acquiring a data table of the MySQL database;
determining the first sub-verification result according to whether the data table is configured with special screening conditions or not;
if the data table is configured with the special screening condition and the special screening condition is not included in the sub-query statement, determining that the first sub-check result is abnormal in the special screening item of the sub-query statement.
Alternatively, the process may be carried out in a single-stage,
the sub-query statement information comprises association conditions of the sub-query statement;
checking whether the associated item of the sub-query statement is abnormal, including:
determining the second sub-verification result according to whether the association condition is the intersection of the unique key of the sub-query statement and the unique key of the basic query statement; the basic query statement is a sub-level basic query statement of the sub-query statement in the resource tree;
and if the association condition is not the intersection of the unique key of the sub-query statement and the unique key of the basic query, determining that the second sub-verification result is the association term abnormality of the sub-query statement.
Alternatively, the process may be carried out in a single-stage,
and checking whether each sub-query statement on the resource tree is abnormal in a traversing mode.
In a second aspect, an embodiment of the present invention provides a verification apparatus for MySQL query statement, including:
the acquisition module is used for acquiring MySQL query sentences to be checked, generating a grammar tree according to the MySQL query sentences, and representing nested relations among query sentences of each layer in the MySQL query sentences divided according to grammar;
the analysis module is used for analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement;
and the verification module is used for verifying whether the sub-query statement is abnormal or not to obtain a verification result.
Alternatively, the process may be carried out in a single-stage,
the verification module is further used for constructing a resource tree taking the sub-query statement as a node;
and the verification module is also used for verifying whether each sub-query statement on the resource tree is abnormal or not to obtain the verification result.
In a third aspect, an embodiment of the present invention provides an electronic device, including a processor, a memory, and a program or an instruction stored on the memory and executable on the processor, where the program or the instruction implements the steps in the method for checking MySQL query statements according to any one of the first aspects when executed by the processor.
In a fourth aspect, an embodiment of the present invention provides a readable storage medium having stored thereon a program or instructions which, when executed by a processor, implement the steps in a method of validating MySQL query statements as described in any of the first aspects.
In the embodiment of the invention, the pre-verification before the data is put into production in MySQL is realized by verifying the MySQL query statement, and the risk of operation hidden danger caused by the problem data is avoided because the problem data cannot be put into production before being verified; and generating a grammar tree according to the MySQL query statement by acquiring the MySQL query statement to be checked; analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement, and accurately obtaining the sub-query statement information; further, the sub-query sentences which are accurately obtained are checked, and the check result is ensured to have high accuracy.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to designate like parts throughout the figures. In the drawings:
FIG. 1 is a flow chart of a method for verifying a MySQL query statement according to an embodiment of the invention;
FIG. 2 is a schematic diagram of a resource tree;
FIG. 3 is a schematic diagram of a node information framework;
FIG. 4 is a code schematic before a first sub-check;
FIG. 5 is a diagram of a code after a first sub-check;
FIG. 6 is a diagram of codes before a second sub-check;
FIG. 7 is a diagram of the code after the second sub-check;
FIG. 8 is a flow chart of a verification method for MySQL query statement according to an embodiment of the invention;
FIG. 9 is a functional block diagram of a check device for MySQL query statement in accordance with an embodiment of the present invention;
fig. 10 is a functional block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The embodiment of the invention provides a method for checking MySQL query sentences, referring to FIG. 1, FIG. 1 is a flow diagram of the method for checking MySQL query sentences, which comprises the following steps:
step 11: acquiring MySQL query sentences to be checked, generating a grammar tree according to the MySQL query sentences, wherein the grammar tree characterizes nested relations among query sentences of each layer in the MySQL query sentences divided according to grammar;
step 12: analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement;
step 13: and checking whether the sub-query statement is abnormal or not to obtain a checking result.
In the embodiment of the invention, the grammar tree is MySQL grammar tree, which is an N-ary tree. Wherein the root node is the outermost query; and node information of the child node may include, by way of example:
1. from: the information of the query comprises: left (base) query node, right query node, association field, association type, etc. (natural join, deduplication join, etc.); if the MySQL query statement comprises a sub-query statement, node information of the sub-query statement is also in the From;
2. where: the screening conditions of the query include: fields for screening, screening values, etc.;
3. fields: a list of fields of a query, comprising: field alias, field length, other special information of the field;
4. on: associated field information, namely information such as field names/values of mutually associated tables;
5. GroupBy: grouping information, i.e. information according to which fields are grouped;
6. having: screening conditions after grouping;
7. OrderBy: ordering information, namely ordering according to which fields, etc.;
8. limit: the number of lines limits, i.e., certain number of lines of the query statement are fetched.
In the embodiment of the invention, the pre-verification before the data is put into production in MySQL is realized by verifying the MySQL query statement, and the risk of operation hidden danger caused by the problem data is avoided because the problem data cannot be put into production before being verified; and generating a grammar tree according to the MySQL query statement by acquiring the MySQL query statement to be checked; analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement, and accurately obtaining the sub-query statement information; further, the sub-query sentences which are accurately obtained are checked, and the check result is ensured to have high accuracy.
In some embodiments of the present invention, optionally, checking whether the sub-query statement is abnormal, to obtain a checking result, i.e. step 13, includes:
step a: constructing a resource tree taking sub-query sentences as nodes;
step b: and checking whether each sub-query statement on the resource tree is abnormal or not to obtain a checking result.
Referring to fig. 2, fig. 2 is a schematic diagram of a resource tree, where the resource tree includes a root query (statement) node, and a base query (statement) node branched by the root query node, and sub-query (statement) 1, 2, 3, and other nodes. Each base query (statement) node includes a base query (statement) node of a sub-level and a plurality of sets of sub-query (statement) nodes of the sub-level. Each sub-query (statement) node includes a base query (statement) node of a sub-level and a plurality of groups of sub-query (statement) nodes of the sub-level. Thus, a tree structure is formed with the root query (statement) node as the main branch and the base query (statement) and the sub-query (statement) as branches.
Referring to fig. 3, fig. 3 is a schematic diagram of a node information frame, where node information is a node information frame of each node (corresponding to the root query (statement) node, the base query (statement) node, and the sub-query (statement) node shown in fig. 2) on a resource tree.
Syntax trees, particularly MySQL syntax trees, are poorly versatile. In the embodiment of the invention, the grammar tree with poor universality is processed into the resource tree with excellent universality by constructing the resource tree taking the sub query statement as the node, thereby laying a foundation for high-efficiency follow-up verification.
In some embodiments of the present invention, optionally, checking whether each sub-query statement on the resource tree is abnormal includes:
step c: checking whether special screening items of the sub-query statement are abnormal or not to obtain a first sub-check result; and checking whether the associated item of the sub-query statement is abnormal or not to obtain a second sub-check result;
step d: and integrating the first sub-verification result and the second sub-verification result to obtain a verification result.
In the embodiment of the invention, the checking result is determined from two aspects by checking the special screening item and checking whether the associated item is abnormal, so that the condition that the checking result is easily interfered by accidental factors under the check of only one aspect is avoided, and the checking result is ensured to have high accuracy.
In some embodiments of the invention, the method, optionally,
checking whether the special screening item of the sub-query statement is abnormal or not, including:
step e: determining a MySQL database to be queried by a MySQL query statement, and acquiring a data table of the MySQL database;
step f: determining a first sub-check result according to whether the data table is configured with special screening conditions or not;
step h: if the data table is configured with special screening conditions and the sub-query statement does not include the special screening conditions, determining that the first sub-check result is abnormal in the special screening item of the sub-query statement.
For example, referring to fig. 4 and 5, fig. 4 is a schematic code diagram before the first sub-check, and fig. 5 is a schematic code diagram after the first sub-check. The SQL query statement of the index (sales performance-day summary) has the problem of filtering conditions, and specifically comprises the following steps: the sub-query statement with the first layer name a has the TEST field-b_is_test unfiltered, and the filtering condition IS 0 (i.e., the sub-query statement does not include a special filtering condition).
In some embodiments of the invention, the method, optionally,
the sub-query statement information comprises association conditions of the sub-query statement;
checking whether the associated item of the sub-query statement is abnormal, including:
step i: determining a second sub-verification result according to whether the association condition is the intersection of the unique key of the sub-query statement and the unique key of the basic query statement; the basic query statement is a sub-level basic query statement of sub-query statement in the resource tree;
step j: if the association condition is not the intersection of the unique key of the sub-query statement and the unique key of the basic query, determining that the second sub-check result is the association term abnormality of the sub-query statement.
For example, referring to fig. 6 and 7, fig. 6 is a schematic diagram of codes before the second sub-check, and fig. 7 is a schematic diagram of codes after the second sub-check. Wherein, the sub-query field is associated with exception, and the SQL query statement of index [ sales performance-date summary ] has associated exception problems, specifically: the sub-query association field of the first tier, which is prd —3, lacks a field-manager ID (i.e., the association condition is not the intersection of the unique key of the sub-query statement and the unique key of the underlying query).
In this example, the intersection (client ID, manager ID) of the unique key (client ID, manager ID) of the view sub-query (temporary table prd _3) and the unique key (client ID, manager ID) of the corresponding base query temporary table base (left query of the same hierarchy) is not equal to the currently associated field set (client ID), i.e., the association condition is not the intersection of the unique key of the sub-query statement and the unique key of the base query.
In some embodiments of the invention, the method, optionally,
and checking whether each sub-query statement on the resource tree is abnormal in a traversing mode.
In order to clearly explain the embodiments of the invention, the following description is made in connection with specific examples.
Referring to fig. 8, fig. 8 is a schematic diagram of a flow for checking by applying the checking method of MySQL query statement according to the embodiment of the present invention, where the flow specifically includes two parts: constructing a resource tree and checking.
Constructing a resource tree part, which specifically comprises the following steps:
A. acquiring an SQL query language (namely acquiring MySQL query sentences to be verified);
B. generating a grammar tree from SQL (i.e., generating a grammar tree from MySQL query statements);
C. analyzing the grammar tree, constructing an N-way tree with the nodes being sub-query statement information (namely constructing a resource tree with the sub-query statement as the node;
the verification part specifically comprises the following steps:
D. traversing the N-ary tree (i.e. checking whether each sub-query statement on the resource tree is abnormal in a traversing way);
E. checking special screening (namely checking whether special screening items of sub-query sentences are abnormal or not to obtain a first sub-check result);
F. checking sub-query connection (namely checking whether the associated item of the sub-query statement is abnormal or not to obtain a second sub-check result);
G. and sorting the results and outputting (i.e. integrating the first sub-verification result and the second sub-verification result to obtain a verification result).
An embodiment of the present invention provides a verification device for MySQL query statement, referring to fig. 9, fig. 9 is a schematic block diagram of a verification device for MySQL query statement in the embodiment of the present invention, where a verification device 90 for MySQL query statement includes:
an obtaining module 91, configured to obtain MySQL query statements to be checked, generate a syntax tree according to the MySQL query statements, where the syntax tree characterizes a nested relationship between query statements of each layer in the MySQL query statements divided according to syntax;
the parsing module 92 is configured to parse the syntax tree to obtain sub-query statement information of the MySQL query statement;
and the verification module 93 is used for verifying whether the sub-query statement is abnormal or not to obtain a verification result.
In some embodiments of the invention, the method, optionally,
the verification module 93 is further configured to construct a resource tree using the sub-query statement as a node;
the verification module 93 is further configured to verify whether each sub-query statement on the resource tree is abnormal, to obtain the verification result.
In some embodiments of the invention, the method, optionally,
the verification module 93 is further configured to verify whether a special screening item of the sub-query statement is abnormal, to obtain a first sub-verification result; and checking whether the associated item of the sub-query statement is abnormal or not to obtain a second sub-check result;
the verification module 93 is further configured to integrate the first sub-verification result and the second sub-verification result to obtain the verification result.
In some embodiments of the invention, the method, optionally,
the verification module 93 is further configured to determine a MySQL database to be queried by the MySQL query statement, and obtain a data table of the MySQL database;
the verification module 93 is further configured to determine the first sub-verification result according to whether the data table is configured with a special screening condition;
the verification module 93 is further configured to determine that the first sub-verification result is abnormal for the special filtering term of the sub-query statement if the data table is configured with the special filtering condition and the sub-query statement does not include the special filtering condition.
In some embodiments of the invention, the method, optionally,
the sub-query statement information comprises association conditions of the sub-query statement;
the verification module 93 is further configured to determine the second sub-verification result according to whether the association condition is an intersection of a unique key of the sub-query statement and a unique key of a basic query statement; the basic query statement is a sub-level basic query statement of the sub-query statement in the resource tree;
the verification module 93 is further configured to determine that the second sub-verification result is an associated term exception of the sub-query statement if the association condition is not an intersection of the unique key of the sub-query statement and the unique key of the base query.
In some embodiments of the invention, the method, optionally,
the verification module 93 is further configured to verify whether each sub-query statement on the resource tree is abnormal in a traversal manner.
The verification device for MySQL query statement provided in the embodiment of the present application can implement each process implemented by the embodiments of the methods of fig. 1 to 8, and achieve the same technical effects, so that repetition is avoided, and no further description is given here.
An embodiment of the present invention provides an electronic device 100, referring to fig. 10, and fig. 10 is a schematic block diagram of the electronic device 100 according to the embodiment of the present invention, including a processor 101, a memory 102, and a program or an instruction stored in the memory 102 and capable of running on the processor 101, where the program or the instruction implements steps in a verification method of any MySQL query statement of the present invention when executed by the processor.
The embodiment of the invention provides a readable storage medium, on which a program or an instruction is stored, which when executed by a processor, implements each process of the embodiment of the MySQL query statement verification method according to any one of the above embodiments, and can achieve the same technical effects, so that repetition is avoided, and no further description is given here.
Wherein the readable storage medium is selected from Read-Only Memory (ROM), random access Memory (Random Access Memory RAM), magnetic disk or optical disk.
The embodiments of the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to the above-described embodiments, which are merely illustrative and not restrictive, and many forms may be made by those having ordinary skill in the art without departing from the spirit of the present invention and the scope of the claims, which are to be protected by the present invention.
Claims (10)
1. A method for verifying MySQL query statements, comprising:
obtaining MySQL query sentences to be checked, generating a grammar tree according to the MySQL query sentences, wherein the grammar tree characterizes nested relations among query sentences of each layer in the MySQL query sentences divided according to grammar;
analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement;
and checking whether the sub-query statement is abnormal or not to obtain a checking result.
2. The method for verifying MySQL query statement of claim 1, wherein:
checking whether the sub-query statement is abnormal or not to obtain a checking result, including:
constructing a resource tree taking the sub-query statement as a node;
and checking whether each sub-query statement on the resource tree is abnormal or not to obtain the checking result.
3. The method for verifying MySQL query statement of claim 2, wherein:
checking whether each sub-query statement on the resource tree is abnormal, including:
checking whether the special screening item of the sub-query statement is abnormal or not to obtain a first sub-check result; and checking whether the associated item of the sub-query statement is abnormal or not to obtain a second sub-check result;
and integrating the first sub-verification result and the second sub-verification result to obtain the verification result.
4. A method of validating MySQL query statements as defined in claim 3, wherein:
checking whether the special screening item of the sub-query statement is abnormal or not comprises the following steps:
determining a MySQL database to be queried by the MySQL query statement, and acquiring a data table of the MySQL database;
determining the first sub-verification result according to whether the data table is configured with special screening conditions or not;
if the data table is configured with the special screening condition and the special screening condition is not included in the sub-query statement, determining that the first sub-check result is abnormal in the special screening item of the sub-query statement.
5. A method of validating MySQL query statements as defined in claim 3, wherein:
the sub-query statement information comprises association conditions of the sub-query statement;
checking whether the associated item of the sub-query statement is abnormal, including:
determining the second sub-verification result according to whether the association condition is the intersection of the unique key of the sub-query statement and the unique key of the basic query statement; the basic query statement is a sub-level basic query statement of the sub-query statement in the resource tree;
and if the association condition is not the intersection of the unique key of the sub-query statement and the unique key of the basic query, determining that the second sub-verification result is the association term abnormality of the sub-query statement.
6. The method for verifying MySQL query statement of claim 2, wherein:
and checking whether each sub-query statement on the resource tree is abnormal in a traversing mode.
7. A verification device for MySQL query statements, comprising:
the acquisition module is used for acquiring MySQL query sentences to be checked, generating a grammar tree according to the MySQL query sentences, and representing nested relations among query sentences of each layer in the MySQL query sentences divided according to grammar;
the analysis module is used for analyzing the grammar tree to obtain sub-query statement information of the MySQL query statement;
and the verification module is used for verifying whether the sub-query statement is abnormal or not to obtain a verification result.
8. The apparatus for verifying MySQL query statement of claim 7, wherein:
the verification module is further used for constructing a resource tree taking the sub-query statement as a node;
and the verification module is also used for verifying whether each sub-query statement on the resource tree is abnormal or not to obtain the verification result.
9. An electronic device, characterized in that: comprising a processor, a memory and a program or instruction stored on the memory and executable on the processor, which when executed by the processor implements the steps in the method of validating MySQL query statements as claimed in any one of claims 1 to 6.
10. A readable storage medium, characterized by: stored on the readable storage medium are programs or instructions which when executed by a processor implement the steps in the method of validating MySQL query statements as claimed in any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310294701.XA CN115994152A (en) | 2023-03-24 | 2023-03-24 | Verification method, device, equipment and storage medium of MySQL query statement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310294701.XA CN115994152A (en) | 2023-03-24 | 2023-03-24 | Verification method, device, equipment and storage medium of MySQL query statement |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115994152A true CN115994152A (en) | 2023-04-21 |
Family
ID=85992484
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310294701.XA Pending CN115994152A (en) | 2023-03-24 | 2023-03-24 | Verification method, device, equipment and storage medium of MySQL query statement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115994152A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106610999A (en) * | 2015-10-26 | 2017-05-03 | 北大方正集团有限公司 | Query processing method and device |
| CN109508339A (en) * | 2018-11-12 | 2019-03-22 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, terminal device and storage medium |
| CN111190924A (en) * | 2019-12-18 | 2020-05-22 | 中思博安科技（北京）有限公司 | Cross-domain data query method and device |
| CN112347123A (en) * | 2020-11-10 | 2021-02-09 | 北京金山云网络技术有限公司 | Data blood margin analysis method and device and server |
| CN113312377A (en) * | 2021-06-11 | 2021-08-27 | 上海天正智能数据服务有限公司 | Automatic-association SQL query statement processing method and device and electronic equipment |
| CN113672781A (en) * | 2021-08-20 | 2021-11-19 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN115114341A (en) * | 2022-08-03 | 2022-09-27 | 西安葡萄城软件有限公司 | Data query method, device and storage medium |
-
2023
- 2023-03-24 CN CN202310294701.XA patent/CN115994152A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106610999A (en) * | 2015-10-26 | 2017-05-03 | 北大方正集团有限公司 | Query processing method and device |
| CN109508339A (en) * | 2018-11-12 | 2019-03-22 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, terminal device and storage medium |
| CN111190924A (en) * | 2019-12-18 | 2020-05-22 | 中思博安科技（北京）有限公司 | Cross-domain data query method and device |
| CN112347123A (en) * | 2020-11-10 | 2021-02-09 | 北京金山云网络技术有限公司 | Data blood margin analysis method and device and server |
| CN113312377A (en) * | 2021-06-11 | 2021-08-27 | 上海天正智能数据服务有限公司 | Automatic-association SQL query statement processing method and device and electronic equipment |
| CN113672781A (en) * | 2021-08-20 | 2021-11-19 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN115114341A (en) * | 2022-08-03 | 2022-09-27 | 西安葡萄城软件有限公司 | Data query method, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104965735B (en) | Device for generating upgrading SQL scripts | |
| US9171100B2 (en) | MTree an XPath multi-axis structure threaded index | |
| CN103793422B (en) | Methods for generating cube metadata and query statements on basis of enhanced star schema | |
| CN111382226A (en) | Database query retrieval method and device and electronic equipment | |
| US20140019941A1 (en) | Data selection | |
| CN110990447B (en) | Data exploration method, device, equipment and storage medium | |
| US11269880B2 (en) | Retroreflective clustered join graph generation for relational database queries | |
| US20060161525A1 (en) | Method and system for supporting structured aggregation operations on semi-structured data | |
| WO2013187816A1 (en) | Method and a consistency checker for finding data inconsistencies in a data repository | |
| CN108776678A (en) | Index creation method and device based on mobile terminal NoSQL databases | |
| CN114090613A (en) | Program statement conversion method, device, equipment and storage medium | |
| CN114238463A (en) | Calculation engine control method and device for distributed index calculation | |
| CN110580170B (en) | Method and device for identifying software performance risk | |
| CN117076742A (en) | Data blood edge tracking method and device and electronic equipment | |
| CN115994152A (en) | Verification method, device, equipment and storage medium of MySQL query statement | |
| US11055275B2 (en) | Database revalidation using parallel distance-based groups | |
| CN110147396B (en) | Mapping relation generation method and device | |
| CN115757174A (en) | Database difference detection method and device | |
| CN113468873B (en) | Syntax analysis method and device of PL/SQL language | |
| CN110472125B (en) | Multistage page cascading crawling method and equipment based on web crawler | |
| Nakabasami et al. | Querying mongodb with linq in a server-side javascript environment | |
| US11281671B2 (en) | Retroreflective join graph generation for relational database queries | |
| CN111090671B (en) | Method and device for eliminating difference between empty character string and invalid character string in database | |
| US20230289332A1 (en) | Lifecycle support for metadata-based data ingestion | |
| CN116339741A (en) | Code generation method based on multiple data streams, safety alarm method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20230421 |
|
| RJ01 | Rejection of invention patent application after publication |