Re: auto_increment Question

2006-06-01 Thread Paul DuBois
At 19:12 +1000 6/1/06, Mark Sargent wrote: Hi All, if a table has an auto_incremented primary key why does the below code require the people_id to be manually inserted? I got this from Beginning PHP, Apache, MySQL Web Development book from Wrox. Curious, as it seems to defeat the purpose of a

Re: auto_increment Question

2006-06-01 Thread Douglas Sims
Hi Mark People_id is the column with auto increment? You can verify that it really does have auto_increment by using the "describe" command. For example: mysql> describe checks; +-+--+--+-+- ++ | Field | Type

auto_increment Question

2006-06-01 Thread Mark Sargent
Hi All, if a table has an auto_incremented primary key why does the below code require the people_id to be manually inserted? I got this from Beginning PHP, Apache, MySQL Web Development book from Wrox. Curious, as it seems to defeat the purpose of auto_increment, no? Cheers. $people = "INSE

Re: auto_increment question

2004-05-09 Thread Mark Fuller
I found the answer to my question by reading the online manual with user comments. Sorry!. Mark - Original Message - From: "Mark Fuller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 09, 2004 12:25 AM Subject: auto_increment question > I wou

auto_increment question

2004-05-09 Thread Mark Fuller
I would like to use "MEDIUMINT UNSIGNED AUTO_INCREMENT". Over time various rows will be deleted. What happens when auto_increment reaches the maximum value? Will it roll over to 1? And, will it begin filling those unused values from past deletes? Thanks, Mark -- MySQL General Mailing List For

Re: Auto_increment question

2003-12-21 Thread Roger Baklund
* Chris W > I have two tables with a one to many relationship: boys and their toys. > I want to know if there are any advantages or disadvantages for each > of the following two ways to create the tables. I am mainly interested > in performance. Either way the insert and select queries aren't a

Auto_increment question

2003-12-20 Thread Chris W
I have two tables with a one to many relationship: boys and their toys. I want to know if there are any advantages or disadvantages for each of the following two ways to create the tables. I am mainly interested in performance. Either way the insert and select queries aren't any more difficu

re: Auto_increment question...

2003-04-01 Thread Egor Egorov
On Tuesday 01 April 2003 08:57, Noel Wade wrote: > Say I have a table with an auto_increment field that is being used at the > primary key. > > When I insert a new record, is there any way to easily grab the primary key > value for that new record? I had another unique field that I was > original

Re: Auto_increment question...

2003-04-01 Thread gerald_clark
Check the manual for last_insert_id(). Noel Wade wrote: Hi All, Say I have a table with an auto_increment field that is being used at the primary key. When I insert a new record, is there any way to easily grab the primary key value for that new record? I had another unique field that I was

Auto_increment question...

2003-03-31 Thread Noel Wade
Hi All, Say I have a table with an auto_increment field that is being used at the primary key. When I insert a new record, is there any way to easily grab the primary key value for that new record? I had another unique field that I was originally going to use to do a select statement; but n

Re: mysql auto_increment question

2002-06-11 Thread Gerald Clark
Taylor Lewick wrote: >Hi all. I have searched the documentation, and i found some info, but I wanted to ask >the lsit a little more about auto_increment. > >First, if I use auto_increment, and then delete a field, I assume mysql leaves the >remaining fields with the original numbers... >i.e.

mysql auto_increment question

2002-06-11 Thread Taylor Lewick
Hi all. I have searched the documentation, and i found some info, but I wanted to ask the lsit a little more about auto_increment. First, if I use auto_increment, and then delete a field, I assume mysql leaves the remaining fields with the original numbers... i.e. if I haverows 1 through 10 and

RE: auto_increment question

2002-03-29 Thread Lopez David E-r9374c
ROTECTED]] Sent: Thursday, March 28, 2002 4:45 PM To: [EMAIL PROTECTED] Subject: auto_increment question This is my first time posting to this list, so please forgive me if I am not doing this correctly. I will break this into post into two parts: what i want to know and why. Is there a way to get

Re: auto_increment question

2002-03-28 Thread Joel Rees
Jeff Habermann asked: > well. Now, because of this deletion, there are sequence gaps in the "idx" > field. We would like to be able to use those numbers again for incoming > clients...Is this possible? It looks like you can, but IMHO, it would probably be more effective to add a DELETED flag to

auto_increment question

2002-03-28 Thread Jeff Habermann
This is my first time posting to this list, so please forgive me if I am not doing this correctly. I will break this into post into two parts: what i want to know and why. Is there a way to get auto_increment fields to fill in gaps in the numbering sequence if some records have been deleted? He

Re: AUTO_INCREMENT question...

2001-06-20 Thread Paul DuBois
>I am currently using MySQL to warehouse real-time data, and I have a couple >of questions regarding AUTO_INCREMENT columns. > >OS: Linux/Solaris >MySQL version: 3.23.33 >Table Types: MYISAM > > >1) The data is only stored for 24hrs. If I do continuous deletes from the >tables, will the AUTO_INCR

AUTO_INCREMENT question...

2001-06-20 Thread Brad Teale
I am currently using MySQL to warehouse real-time data, and I have a couple of questions regarding AUTO_INCREMENT columns. OS: Linux/Solaris MySQL version: 3.23.33 Table Types: MYISAM 1) The data is only stored for 24hrs. If I do continuous deletes from the tables, will the AUTO_INCREMENT colu

RE: AUTO_INCREMENT question

2001-01-17 Thread Quentin Bennett
HI, Yes, but unfortunately, you need to upgrade to 3.23 to get this behavior. Regards Quentin -Original Message- From: luisma [mailto:[EMAIL PROTECTED]] Sent: Thursday, 18 January 2001 12:03 To: [EMAIL PROTECTED] Subject: AUTO_INCREMENT question I have a column, lets say &qu

AUTO_INCREMENT question

2001-01-17 Thread luisma
I have a column, lets say "id", that is AUTO_INCREMENT. In it the most recently inserted row got an ID value of 100. Now, lets say I kill off some rows from before, and crunch down the IDs so that there are no skips in numbers, and now the most recently inserted row has an ID of 85. Wh