Database Administration
Format Dates in MySQL With DATE_FORMAT
One DATETIME, three presentations: the DATE_FORMAT specifiers that matter (minutes are %i, never %m), DATEDIFF and DATE_ADD arithmetic, a monthly report, and when the…
//
Category: Database Administration
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
Export MySQL Query Results to a CSV File
SELECT ... INTO OUTFILE turns any query into a spreadsheet file, written by the server itself. Handle the quoting that keeps embedded commas safe,…
Database Administration
Combine Query Results With UNION in MySQL
A join widens a row by adding columns; UNION instead stacks one result on top of another. Build a single contact list from a…
Database Administration
Write a Subquery in MySQL
Write a subquery in MySQL to answer a question inside a question - a SELECT nested in another statement's WHERE or column list. This…