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
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 UN
* 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
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
Jeff
You can make a clean start but it takes work.
1) create new table clients_tmp - same fields - no indexes.
add a field and make it a simple integer - say idx_int
2) insert all the fields into client_tmp from clients
place the client.idx field into client_tmp.idx_int
a) At th
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_INCR
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 "id", tha
10 matches
Mail list logo
