masthead image
Mysql database management system

Mysql Command Handbook

Thursday June 10 2010, 03:48 AM

Here's a quick MySql handbook that I think you will find useful. It consists of common MySql commands that you can enter in on the Mysql client program.

Importing A Mysql SQL File

Monday September 14 2009, 01:17 AM

Here's a quick way to backup your Mysql database on your host and deliver it onto your local development environment. This is very useful for websites that use content management systems (CMS) where the data is generated on the hosting site and not locally.

MySql AutoIncrement "Bug"

Thursday August 20 2009, 02:06 PM

This afternoon I was taking a look at one of my Mysql databases doing record counts and noticed a problem. What I was seeing as the actual record count using MySQL Query Browser didn't match with the auto incremented identifier column.

Using MySql with VB.NET

Saturday August 15 2009, 04:09 PM

Every now and then when I have a sudden burst of programming inspiration I reach inside my programming toolbox and pull out an old trusty friend - Visual Basic. Over the years I've appreciated the benefits of using VB. One of them is not having to spend countless days creating a Windows GUI application the old fashioned way by using C/C++. WndProc, GetMessage, and RegisterClass are things I used to do a decade ago as a Windows developer and it was a real pain.

Microsoft has graciously offered a free version of VB called Visual Basic Expression Edition. This product has some limitations but as far as I am concerned, its a nice little utility to prototype Windows applications quickly.

In this article, I discuss how to integrate MySql with VB.Net.

How To Setup A WAMP Development Environment

Tuesday January 13 2009, 09:48 PM

This article will discuss in detail how to setup a local Windows Apache, MySQL, and PHP (WAMP) development environment.

MySQL 5.1 Install Problems

Tuesday January 13 2009, 07:21 PM

If you are having problems installing MySQL 5.1 for Windows and are reading this, you are not alone. Over the past 5 hours I have beaten my head trying to install this thing to no avail.