Personal tools
You are here: Home Mysql How To's
Navigation
Log in


Forgot your password?
 
Document Actions

How To's

Up one level

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
 
Security for databases
Which solution database auditing and protection do you use?









Polls