SHOW TABLE STATUS & Autoincrement???

Can someone please tell me what the Auto_increment field in the SHOW
TABLE STATUS output means? I checked the online documentation and
couldn't get much help.

Thanks for your help

soup_or_power@yahoo.com wrote:
> Can someone please tell me what the Auto_increment field in the SHOW
> TABLE STATUS output means? I checked the online documentation and
> couldn't get much help.

Huh? How the hell have you searched?
http://dev.mysql.com/doc/refman/5.0/...le-status.html

Auto_increment
The next AUTO_INCREMENT value.

So: the value the next inserted row will get in it's auto_increment field.

Grtz,
--
Rik Wasmus

It means that when no value is supplied for this field, a value is
automatically inserted - at an increment of the preceding value. Try it
yourself. Make a table like

CREATE TABLE `test` (
`id` INT ( 5 ) NOT NULL AUTO_INCREMENT ,
`f_name` VARCHAR( 12 ) ,
`l_name` VARCHAR( 12 ) ,
PRIMARY KEY ( `id` )
) ;

Insert something like this into your table (where the first value in
each INSERT statement represents the auto-incremented field) and see
what you get:

INSERT INTO table VALUES ('','John'.'Lennon');
INSERT INTO table VALUES ('','Paul'.'MacCartney');
INSERT INTO table VALUES ('','George'.'Harrison');
INSERT INTO table VALUES ('','Ringo'.'Starr');

It means that when no value is supplied for this field, a value is
automatically inserted - at an increment of the preceding value. Try it
yourself. Make a table like

CREATE TABLE `test` (
`id` INT ( 5 ) NOT NULL AUTO_INCREMENT ,
`f_name` VARCHAR( 12 ) ,
`l_name` VARCHAR( 12 ) ,
PRIMARY KEY ( `id` )
) ;

Insert something like this into your table (where the first value in
each INSERT statement represents the auto-incremented field) and see
what you get:

INSERT INTO table VALUES ('','John'.'Lennon');
INSERT INTO table VALUES ('','Paul'.'MacCartney');
INSERT INTO table VALUES ('','George'.'Harrison');
INSERT INTO table VALUES ('','Ringo'.'Starr');