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
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
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
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
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
* 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
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
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
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
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
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.
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
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
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
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
>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
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
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
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
19 matches
Mail list logo
