How To's

This topic contains hints and procedures step by step about how to do DBA tasks on MySQL Database.

8 Essential MySQL Queries — by Josana Bujokas da Rosa — last modified 2009-01-30 09:05

Here's a list of queries used very often and that save a lot of development time.

Advanced MySQL user variable techniques — by Josana Bujokas da Rosa — last modified 2009-01-30 18:13

MySQL’s user variables have interesting properties that enable the useful techniques. One property is that you can read from and assign to a user variable simultaneously, because an assignment can be an r-value (the result of the assignment is the final value of the variable). Another property, which sometimes causes confusing behavior, is un-intuitive evaluation time. This post show you how to make sure your variables get updated at the time they’re used, instead of potentially reading and updating them at different stages of query execution. This technique enables a whole new range of applications for user variables. As a bonus, it also avoids extra columns of output created by variable manipulations.

How to Create a MySQL Database — by Josana Bujokas da Rosa — last modified 2009-01-30 18:11

How to Create a MySQL Database

How to recover mysql root password — by Pawan — last modified 2009-04-13 19:07

 

How to change the mysql database location — by Pawan — last modified 2009-04-13 18:56

 

images — by Vinícius Perallis — last modified 2010-07-09 14:40