Hello.
On Fri 2002-06-21 at 10:47:28 -0400, [EMAIL PROTECTED] wrote:
> On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote:
>
> > IMHO, the interesting question is: how could the tables get out of
> > sync, in a way that foreign keys would be able to prevent? I am not
> > able to see a way
On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote:
> IMHO, the interesting question is: how could the tables get out of
> sync, in a way that foreign keys would be able to prevent? I am not
> able to see a way in everyday work (explicitly filling in nonsense
> does not count).
>
> The only
Hi.
On Thu 2002-06-20 at 14:50:07 -0700, [EMAIL PROTECTED] wrote:
> Friends,
>
> I am designing a MySql DB schema that will use foreign
> keys similar to:
>
> create table orders(id int auto_increment primary key,
> amount double(7,2) );
>
> create table orderItems(id int, item char(20), price
Friends,
I am designing a MySql DB schema that will use foreign
keys similar to:
create table orders(id int auto_increment primary key,
amount double(7,2) );
create table orderItems(id int, item char(20), price
double(5,2), quantity int, key(id), foreign key id
references orders (id));
I am cu
