Database Administration
Query Hierarchical Data With a Recursive CTE in MySQL
Walk a category tree stored as a flat parent_id column using WITH RECURSIVE. This tutorial builds the anchor and recursive member, adds a depth…
//
Tag: Database Design
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…
Database Administration
Create a View in MySQL
A view stores a SELECT under a name, so you can query it like a table while the data stays live in the base…
Database Administration
Create a MySQL Table From the Terminal
Create a MySQL table from the terminal with a single CREATE TABLE statement: typed columns, an AUTO_INCREMENT primary key, and sensible defaults, confirmed with…