Autoincrement Weirdness

wxdqz

New Member
Hi guys,

I'm using a MySQL database, version 3.23.37.

I've set up a table with the SQL statement:

// Create the Client Info Table
$query[] = "CREATE TABLE clientinfo (
client_id mediumint DEFAULT '0' NOT NULL auto_increment,
clientname varchar(50) NOT NULL,
PRIMARY KEY (client_id) );";

However, when I start adding data into the database it starts at 1 and not 0. Anyone know why this might be?
Anyone know how I can fix this?

Cheers,

Owen
 
Back
Top