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…
//
Category: Database Administration
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…
Database Administration
Add a Column to a MySQL Table With ALTER TABLE
Add a column to a MySQL table with ALTER TABLE - no drop, no re-import, the data stays put while the schema changes. This…