Re: Auto Increment Column

mmy System Administrator & Web Developer http://www.dalar.net - Original Message - From: "Naresh Sadhnani" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 12, 2004 3:35 PM Subject: RE: Auto Increment Co

RE: Auto Increment Column

: 12 August 2004 13:25 To: Naresh Sadhnani; [EMAIL PROTECTED] Subject: Re: Auto Increment Column | Subject: Auto Increment Column | | Hi, | | Does anyone know how to extract only the Auto_Increment column from | the command results of "SHOW TABLE STATUS" Do you mean that you want a co

Re: Auto Increment Column

| Subject: Auto Increment Column | | Hi, | | Does anyone know how to extract only the Auto_Increment column from the | command results of "SHOW TABLE STATUS" Do you mean that you want a command that will run on the command line that will show the value of the Auto_Increment column?

Auto Increment Column

Hi, Does anyone know how to extract only the Auto_Increment column from the command results of "SHOW TABLE STATUS" Regards Naresh -- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you hav

Re: Innodb table with auto-increment column doesn't create (err 1005)

type=in nodb; ERROR 1005: Can't create table './test/stundenliste.frm' (errno: 121) mysql> " Regards, Heikki Innobase Oy sql query Subject: Innodb table with auto-increment column doesn't create (err 1005) From: Smurf Date: Thu, 30 Jan 2003 11:04:18 +

Innodb table with auto-increment column doesn't create (err 1005)

>Description: Table not creatable >How-To-Repeat: mysql> create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql> create table stundenliste (id int auto_increment) type=in

Re: fix auto increment column

Yamin, Monday, July 22, 2002, 11:15:30 AM, you wrote: YP> I had a auto increment column YP> let say the auto increment would look like this YP> 100,1001,1003,1101,1103,10005,10006 YP> yes I had delete several column in tha past YP> now I would like to sort it again so it wo

fix auto increment column

Hi ppl I had a auto increment column let say the auto increment would look like this 100,1001,1003,1101,1103,10005,10006 yes I had delete several column in tha past now I would like to sort it again so it would be an order from 100 to 1006 is it possible for mysql to do that with out drop

Re: Starting value for an auto increment column?

> Is there a way to specify a starting value for an auto increment > column? Take a look at the CREATE TABLE syntax. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesi

Re: Starting value for an auto increment column?

a way to specify a starting value for an auto increment > column? > > I tried this: > idINTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT > > But, that did not work. > > Thanks, > Neil. > > -- > Neil Aggarwal > JAMM Consulting, Inc.(972)

Starting value for an auto increment column?

Hello: Is there a way to specify a starting value for an auto increment column? I tried this: id INTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT But, that did not work. Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com