Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 

Delete records from multiple tables with one query

Author: rootsql on 7-11-2011, 22:23

 

How to delete records from multiple tables with one query.

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

Author: rootsql on 7-11-2011, 22:17

 

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

Rank records (grouped ranking)

Author: rootsql on 7-11-2011, 22:09

 

How to rank records (grouped ranking).

Custom ordering (order rows by my order)

Author: rootsql on 1-11-2011, 22:51

 

Custom ordering (order rows by my order).

Rank records

Author: rootsql on 1-11-2011, 22:34

 

Example shows how to rank records in a table.

Select N latest records in a group

Author: rootsql on 1-11-2011, 22:30

 

Select N latest records in a group.

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

Author: rootsql on 1-11-2011, 22:24

 

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

Copy data from one tabe to a new table

Author: rootsql on 1-11-2011, 22:20

 

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

Copy data from one tabe to another

Author: rootsql on 1-11-2011, 22:08

 

Copy data from one tabe to another

Get updated value from UPDATE statement without querying the table again

Author: rootsql on 1-11-2011, 22:04

 

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