Re: mysql auto-increment

Elias, ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html Regards, =dn > I would like to know if it is possible to configure mysql auo increment > feild to start from a specific number or configure it to have a specific > character such as a letter inserted infront of it

Re: mysql auto-increment

pwards. I haven't tried this yet, so I don't know if it works... Gavin Alexander From: [EMAIL PROTECTED] Date: Tue, 27 Aug 2002 06:22:23 -0600 To: [EMAIL PROTECTED] Subject: mysql auto-increment I would like to know if it is p

mysql auto-increment

I would like to know if it is possible to configure mysql auo increment feild to start from a specific number or configure it to have a specific character such as a letter inserted infront of it. Thanks " I have no respect for reality as soon as it is acknowledged as such. I am interested

MYSQL auto-increment not working as desired

Hi, I have a MyISAM table which has a run_id which together with user_id forms the primary key for the table. run_id is not null and auto-increment. I delete records from this table, and add new records. I want the run_id to keep incrementing and not reuse values, but here is the actual behavior:

Re: MYSQL Auto-Increment Field increment by itself

rns 0. insert is fine, MySQL is fast enough, I can clear useless rows daily. of cos, I am expecting the new release with Sequence support~ Borus > ÅÇ´f¼Ù(Borus.Kung) a écrit : > > > > Hi all, > > > > I have a serious problem. > > I have a production system just

Re: FW: MYSQL Auto-Increment Field

Kaan, Wednesday, June 12, 2002, 2:10:08 PM, you wrote: >> I have set up a table with 3 fields. But I have forgetten to add a primary >> key (I'm not sure if its a primary key I want, I just want a >> auto-Increamentig field at the begging of the table. >> can anyone tell me how I do this. Take a

Re: MYSQL Auto-Increment Field increment by itself

ÅÇ´f¼Ù(Borus.Kung) a écrit : > > Hi all, > > I have a serious problem. > I have a production system just launch using MySQL. > auto increment field is used in the system by ASP, Visual Basic and C. > System is using AIX 4.3.3, MySQL 3.23.49 > gcc 2.9 source code compi

MYSQL Auto-Increment Field increment by itself

Hi all, I have a serious problem. I have a production system just launch using MySQL. auto increment field is used in the system by ASP, Visual Basic and C. System is using AIX 4.3.3, MySQL 3.23.49 gcc 2.9 source code compiled MySQL There are some C compiled process using auto increment field

FW: MYSQL Auto-Increment Field

> Hi, > I have set up a table with 3 fields. But I have forgetten to add a primary > key (I'm not sure if its a primary key I want, I just want a > auto-Increamentig field at the begging of the table. > > can anyone tell me how I do this. > > Cheers > sql -

Trouble With MySQL Auto-Increment

Hello All, I have been using mysql-3.23.29a-gamma-dec-osf4.0f-alphaev6 running on a machine running Digital UNIX V4.0F. Since upgrading the database from 3.22 to 3.23, auto-increment fields have been acting strangely. A brief description of the table looks like: ++-