Mysql query

1

Basically I am having problems inserting an auto_increment column in my new table. I am not sure of the format but I believe that it’s:

Order INIT(5) UNSIGNED AUTO_INCREMENT

This would insert a new column right?

But if I try to test the table by manually inserting the information into it and I don’t enter a value for this column it returns an error because the values don’t match the columns in terms of numbers. I thought that auto_increment was just that.

As I am writing this I am figuring out the problem,

any ideas would be good though

regards

2

Doing it manually is a pain. I suggest you look up a set of scripts called phpMyAdmin. Makes adding colums deleteing, doing anything imaginable with MySQL a lot simpler.

3

you can download phpMyAdmin from: