MySQL

The Web is getting Sloppy, Why is it a Problem and Who’s Fault is it?

Lately I’ve observed a few web sites that have been “re-launched”. Web sites vary from a small time blogger, a popular car forum, a very large automotive vendor and even Google! First, let me define what I mean by “The web is getting sloppy”. Essentially the Internet is organized by domain names, for example www.google.com. […]

Columbus PHP Meetup tonight – The Art of SQL Tuning for MySQL

If you’ve been following my Twitter (@AngeloMandato) lately, you may have herd me mention previous Columbus PHP Meetups. These meetups are great for meeting fellow PHP programmers in the Columbus area and a great way to learn about different libraries, techniques and frameworks that are available. Columbus PHP Meetup web site: http://php.meetup.com/93/ Tonights meetup topic […]

Sun acquires MySQL

If you have not herd, Sun Microsystems is acquiring MySQL. I think this is a great move, especially since Sun has embraced the open source community as strong, if not stronger, than other large companies such as IBM, Yahoo and Google. Article: http://www.mysql.com/news-and-events/sun-to-acquire-mysql.html I think the move is a good one for MySQL. With the […]

AJaxMyTop – mtop for the web browser

If you like to monitor MySQL, you are going to love this application. http://ajaxian.com/archives/779 AJAXMyTop is a simple web application that allows you to monitor the currently executed queries on your MySQL server.  It is pretty useful, especially when you are trying to diagnose page loading issues.

I stumbled upon this great example how to write a MySQL LEFT JOIN today. It explains pretty well what they are used for and how to write one. Check it out. http://www.tizag.com/mysqlTutorial/mysqlleftjoin.php One thing that should be explained better is what a regular JOIN is. You don’t have to say the word JOIN, but basically […]