MySQL Tips & Tricks

Friday, June 6, 2008

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

Labels: , ,

posted by zzapper at 3:23 PM

2 Comments:

  • dont worry about db management tool when you have sqlyog. ZZaaper is absolutely rite. check it out, you wont regret later

    By Blogger Shaun, At June 29, 2008 9:39 AM  

  • Shaun,
    thanks for agreeing, I've tried a few MySQL GUIs as well as the dreadful one by MySQL themselves which they evtually abandoned
    zzapper

    By Blogger zzapper, At July 6, 2008 2:34 PM  

Post a Comment



<< Home