Make homepage|Add to favorites
 

MYSQL TOOLS
reviews, articles, tips & snippets

 
Buy SQL » Tag Cloud » Tips

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).

Dynamic pivot tables (transform rows to columns)

Author: rootsql on 1-11-2011, 21:50

 

Dynamic pivot tables (transform rows to columns)

MySQL cheat sheet

Author: Dicentis on 1-11-2011, 18:15

MySQL cheat sheet notepadWhen developing an internet site, you may often see developers making recurring mistakes when designing databases.

Today I decided to publish own FAQ answers for working with MySQL.


 

 

 

Working with MySQL backups


Creating a backup:

mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql


Creating a database structure without data:
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql

MySQL pivot tables (transform rows to columns)

Author: rootsql on 31-10-2011, 23:14

 

Pivot tables (transform rows to columns)