SQL query method and system

A query method and query statement technology, applied in the field of SQL, to achieve the effect of improving system stability, reducing the amount of code, and improving the ability of rapid delivery

Inactive Publication Date: 2017-07-04
AEROSPACE INFORMATION
View PDF2 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention aims to solve the problems described above

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
  • SQL query method and system
  • SQL query method and system
  • SQL query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0013] Generally speaking, the basis of the query is the SQL statement. Then as a query, the standard syntax of SQL statements (DB2; ORACLE; MYSQL; INFORMIX; SQLSERVE...

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 present invention provides an SQL query method and system. The method comprises: defining an SQL query statement, wherein a structure of the SQL query statement comprises a Select display field, a FROM table name, a where query condition, an order by ordering field and a group by grouping field; and according to the defined SQL query statement, performing a query operation. According to the method and system provided by the present invention, structural design and flexible definition are performed based on the statement fundamentally, so that the operating efficiency of query is improved.

Description

technical field [0001] The invention relates to the field of SQL, in particular to an SQL query method and system. Background technique [0002] With the development of information technology, more and more information systems have entered the lives of ordinary people. They bring more convenience to people. Of course, with the use of the business system, people's requirements for it have also increased, so end users put forward more functional requirements. In order to quickly respond to the changing needs of users, our technicians continue to improve these systems day and night. . [0003] In fact, as a business system, no matter how complex or simple it is, it is inseparable from the four actions of "adding, deleting, modifying, and checking" data. Among them, the system is inseparable from the action of "check" when performing the three actions of "addition, deletion, and modification". It can be seen that the query action is very important in the system, and in actua...

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): G06F17/30
CPCG06F16/90335
Inventor 柳阁文贾希强陈懿崔真真楼钧连俊吕韬
Owner AEROSPACE INFORMATION
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