Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > mysql 复合索引，前后顺序

mysql 复合索引，前后顺序

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-06 09:32:51
Original
1612 people have browsed it

mysql索引

表用来保存设备传送来的采集信息
设备暂定10000台，日后会继续增加，每5S传送一个采集信息，一个月度表，千万条记
问题：
设备Id和采集时间在索引中的先后顺序，应该哪个在前哪个在后，

Related labels：
mysql 索引
Previous article：mysql 用like模糊查询 怎么查包含了%号的字符串 Next article：mysql 列字符串拼接问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
I would like to ask if PHP can develop green Internet software or scripts?
From 1970-01-01 08:00:00
0
0
0
Does idea git have the > icon that prompts when the file status changes like eclipse, or a similar icon?
From 1970-01-01 08:00:00
0
0
0
Why can't jQuery or DOM methods like getElementById locate elements?
From 1970-01-01 08:00:00
0
0
0
javascript - js and c++ encryption and decryption through des
From 1970-01-01 08:00:00
0
0
0
Questions about gettype and var_dump?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template