Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for querying and analyzing associated purchase rate based on MySql

A data and self-defined technology, applied in structured data retrieval, instruments, electronic digital data processing, etc., can solve problems such as wrong marketing, achieve the effect of increasing sales, widening the scope of inquiry, and facilitating customer analysis and marketing

Pending Publication Date: 2021-12-21
北京慧博科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the field of sales, how to sell related products is very important for merchants, but the relevance defined by merchants and the relevance understood by users are not the same, and wrong marketing may often get twice the result with half the effort

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
  • Method for querying and analyzing associated purchase rate based on MySql

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] 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 only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art belong to the scope of protection of the present invention. In order to facilitate the understanding of the above-mentioned technical solutions of the present invention, the above-mentioned technologies of the present invention will be described below through specific usage methods The plan is described in detail.

[0020] Such as figure 1 As shown, according to the method for analyzing the joint rate based on MySql query described in the embodiment of the present invention, the implementation steps include: first, the user enters the joint rate analy...

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 method for querying and analyzing the associated purchase rate based on MySql. The method comprises the following steps that a user enters an associated purchase rate analysis page, selects or inputs order data parameters to be queried, and submits a user-defined task; receiving order data parameters of the custom task, transmitting the parameters to a background, and then executing the custom task by the MySql; the MySql executes the self-defined task, and after the MySql executes the self-defined task, the table for calculating the associated rate result is stored in a database result table; and when the user inquires the task state and the task result, the user association rate analysis page returns the user-defined task execution result and state to the user according to the data of the database result table. According to the method, the associated purchase rate is analyzed through the complete and efficient mysql data table, and the association and relevance among the commodities can be more clearly seen from the aspect of specific data; merchants are helped to reasonably promote commodities, and the sales volume is improved.

Description

technical field [0001] The present invention relates to the technical field of computer application, in particular to a method for querying and analyzing joint rate based on MySql. Background technique [0002] In the field of sales, how to sell related products is very important for merchants, but the relevance defined by merchants and the relevance understood by users are not the same, and wrong marketing may often get twice the result with half the effort. For shopping centers that pursue multi-format mixed consumption, joint consumption is the core of shopping center operations. When the brand portfolio is fixed, the increase in unit price depends on whether the joint rate can be increased. Contents of the invention [0003] Aiming at the above-mentioned technical problems in the related art, the present invention proposes a method for analyzing joint rate based on MySql query, which can overcome the above-mentioned shortcomings of the prior art method. [0004] For r...

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/245G06F16/28G06Q30/06
CPCG06F16/2282G06F16/245G06F16/284G06Q30/0635
Inventor 王连喜
Owner 北京慧博科技有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products