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 =
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
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
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
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 would like to use MEDIUMINT UNSIGNED
* 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
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
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
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
originally
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
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
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. if I
: 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 auto_increment
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?
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
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
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
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
18 matches
Mail list logo