Database Administration
Add a Generated Column in MySQL
A generated column holds a value MySQL computes from the rest of the row, so it can never drift out of step. This tutorial…
//
Tag: Indexes
Database Administration
Insert or Update a Row With ON DUPLICATE KEY UPDATE in MySQL
One statement that inserts a new sku or updates the one already stocked: the row alias that reads your own values, a whole feed…
Database Administration
Search Text With a MySQL FULLTEXT Index
Replace a slow LIKE '%word%' with a FULLTEXT index: rank matches by relevance in natural-language mode, require or exclude terms in boolean mode, and…
Database Administration
Create an Index and Read EXPLAIN in MySQL
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…