1. Membership table: There are fields such as membership card number, name, phone number, gender, points, etc. (tens of millions of data) 2. Consumption record table: associated field membership card number (tens of millions of data, divided into tables, divided according to consumption time) The following are search conditions. Now you need to find the corresponding member list according to the search conditions (the total number needs to be counted) For example: query all members whose age is 46-60 years old, gender: female, whose points are between 100-200, who have consumed twice in the past 90 days and the consumption amount is 100-200 yuan, and count the total number.

PHP+mysql member and consumption record table big data connection query, how to solve it, urgently looking for a solution-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

PHP+mysql member and consumption record table big data connection query, how to solve it, urgently looking for a solution

古月 2019-06-02 18:54:51

1202

1.会员表：有会员卡号，姓名，电话，性别，积分等字段（千万级数据）
2.消费记录表：关联字段会员卡号（千万级数据，有分表，按消费时间分表）

以下为搜索条件，现需要根据搜索条件查出对应的会员列表（需统计总数量）

如：查询会员年龄在46-60岁，性别：女，积分在100-200之间，近90天内消费过2次且消费金额在100-200元直接的所有会员，并统计总数

图片1.png