Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 

Drop multiple tables named with prefix

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

 

How to drop multiple tables named with prefix (or named with similar pattern).

Delete related records with one query

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

 

How to delete related records with one query (using ON DELETE CASCADE foreign key).

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.