27 Oct · Robert Eisele
Efficient Flag-Based Counts in MySQL
A practical MySQL pattern for counting the union of a fixed set of flags across grouped records. A translator-and-document example derives the...
Databases
Contents
- Analyze User Activity Patterns with MySQL and PHP
- A Programmable Query Layer on Top of MySQL
- Avoid N+1 Queries with MySQL JSON Aggregation
- Build a Circular Buffer in MySQL
- Building a Tag Cloud with MySQL
- Calculate Age Correctly in MySQL
- Calculate the Next Birthday in MySQL
- Can MySQL Query Parsing Be Avoided?
- Connect to Microsoft SQL Server with Python
- Efficient Flag-Based Counts in MySQL
- Efficient Pagination in MySQL
- Finding Friends of Friends with MySQL
- Finding People Near You with MySQL 8.4
- Full-Text Location Search with MySQL 8.4
- How It Was Possible to Get Root Access Through MySQL
- Import Wikipedia into MySQL with MediaWiki
- Indexing Text Columns in MySQL 8.4
- Mask IPv6 Addresses with MySQL
- Model Many-to-Many Relationships in MySQL
- MySQL Wishlist Revisited for MySQL 8.4
- Persisting a Custom Sort Order in MySQL
- Preserve ON UPDATE CURRENT_TIMESTAMP in MySQL
- Reliable Asynchronous Writes with MySQL
- Running Standard Deviation in MySQL
- Set and Clear Bit Flags Atomically in MySQL
- Should MySQL VARCHAR Lengths Be Powers of Two?
- SQL NULL and Three-Valued Logic
- Statistical Analysis with MySQL 8.4
- Stream SQL to MySQL with Netcat
- TF-IDF Related-Article Ranking with MySQL 8.4
- The Best SQL Mode Configuration for MySQL 8.4