SQL Commands

As your website gets more traffic, you’ll find that you run into problems where MySQL slows down. It has to wait for existing users to […]

If you are using WordPress on a Microsoft Windows server, using IIS to manage your website, then you can easily run into permissions problems as […]

If you do a lot of work with MySQL, you’re probably using MySQL Workbench to manage your databases and schemas. Once you start working with […]

When you use reports in MySQL, you expect them to be accurate. Let’s take, for example, the MySQL Schema Inspector. When you use the schema […]

There are all sorts of reasons you might want to compare data between two tables in different schema. A common situation is that you’re moving […]

This example is a lesson in double-checking what you think you’re seeing. I just invested a half hour in trying to solve a problem which […]

You’ve got your MySQL database up and running. Everything is going smoothly. But then for some reason you need to change your MySQL schema name. […]

One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes and other special characters. Here is […]

Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together! This isn’t even […]

If you are working with a MySQL database, it is important to optimize the database so it runs as quickly as possible. Here are some […]