Test your MySQL queries inside a MySQL GUI before coding them

Before you start coding your application with PHP or whatever remember to test out your MySQL in your MySQL GUI such as SQLYOG or even the CLI

What are the advantages?

• You don't have to worry about the Script/MySQL syntax clashes (quoting etc)
  
• You only have to think MySQL and not say PHP as well
• You can see the data produced or not produced
• You can test your concepts