Archive for December, 2007

Makefiles made easy

Thursday, December 6th, 2007

Makefiles are quite simple and easy to use once you have learned the basics. I always felt that they were daunting due to the sheer size of most open source project make files. So I decided to start small, and work my way up. So, to help you get started with them I will start with the basics. (more…)

Political Madness

Thursday, December 6th, 2007

Right vs. Left that is how it has always been, Republicans vote against anything the Democrats want. Democrats vote against anything the Republicans want. For our own good this dangerous trend must end! (more…)

Changing auto_increment on MySQL

Thursday, December 6th, 2007

From time to time, when programming with MySQL, I have needed to change the auto_increment value to something other than the default (Typically it starts counting with 1 and goes up from there). To change this, simply use the following command:

mysql> ALTER tablename AUTO_INCREMENT=new_number

There you go, it is that easy to change the auto increment value for MySQL.

NOTE: I have discovered that MySQL will not allow you to set the auto_increment value to a number smaller that what is currently set. The data must be truncated and then set to get it to work properly.

Switch to our mobile site