Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 

Select latest one from each category (group-wise max in a group query)

 

How to select latest one from each category (group-wise max in a group query)

Rank records (grouped ranking)

 

How to rank records (grouped ranking).

Custom ordering (order rows by my order)

 

Custom ordering (order rows by my order).

Rank records

 

Example shows how to rank records in a table.

Select N latest records in a group

 

Select N latest records in a group.

Copy data from one tabe to another (update existed records)

 

Copy data from one tabe to another (update existed records).

Copy data from one tabe to a new table

 

How to copy data from one tabe to a new table.

Copy data from one tabe to another

 

Copy data from one tabe to another

Get updated value from UPDATE statement without querying the table again

 

Shows how to get the value from updated row in one query (without additional SELECT query).

Dynamic pivot tables (transform rows to columns)

 

Dynamic pivot tables (transform rows to columns)