ginal Message-
From: Tim Foster [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 9:42 AM
To: PHP DB
Subject: RE: [PHP-DB] help me on projecting some tables
A couple of questions:
> INSERT INTO traits VALUES("Added Chemicals",LAST_INSERT_ID(),"Sugar");
1
A couple of questions:
> INSERT INTO traits VALUES("Added Chemicals",LAST_INSERT_ID(),"Sugar");
1. Will LAST_INSERT_ID() work reliably in a multi-user environment? What happens if
you're
in the middle of inserting a dozen records and someone else inserts a record? Does
MySQL
keep the LAST_INS
yep, that first example was roughly what i was getting at, don't think i
explained it anywhere near as well as Rick though.
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 16 November 2001 14:17
To: PHP DB
Subject: RE: [PHP-DB] help me on projecting some t
S(NULL,"Bread",1,"each",1.49);
INSERT INTO styles VALUES( "White",LAST_INSERT_ID() );
INSERT INTO styles VALUES( "Black",LAST_INSERT_ID() );
INSERT INTO styles VALUES( "Wheat",LAST_INSERT_ID() );
INSERT INTO styles VALUES( "Hawaiian",LAST_INS
not really sure how to do this, other than planning for as much as you can
in your original tables, then have a spare table with four columns - Row_ID,
Characteristic_Name, Characteristic_Value, and Product_Refer_ID.
so then if you get a new characteristic (eg colour) then you could have
values 1,