I don't enjoy being a PITA but could you teach your MUA to create
proper attributions? This makes it really hard to tell who said
what, leads to confusion, and may piss of quite a few people if a
debate gets somewhat heated...
# [EMAIL PROTECTED] / 2003-04-02 18:18:17 +0200:
> > #
I mean, at least that's how I reacted upon reading..
"
For MyISAM tables, you can work around the lack of ON DELETE by adding
the appropriate DELETE statement to an application when you delete
records from a table that has a foreign key. In practice this is as
quick (in some cases quicker) and much
# [EMAIL PROTECTED] / 2003-04-02 17:37:26 +0200:
> And from this page:
> http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
> I understand it is rather recommended NOT to use foreign keys, at least
> until mysql integrates it more fully.
which part of that page makes you say that?
--
Fr
Thank you for your explanations, after 4 interventions I now know much
more about the difference between primary, unique, index and I've learnt
that foreign keys exits in my sql ;-)
And from this page:
http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
I understand it is rather recommended NO
X-Mailer: Microsoft Outlook, Build 10.0.2616
your MUA wrap-mutilates quoted text.
# [EMAIL PROTECTED] / 2003-04-02 02:34:01 +0200:
> > 1. If a column is a primary key, there is no need to declare it a
> > unique.
>
> Thank you, I was doing that for every table sinc
Peter,
>1. If a column is a primary key, there is no need to declare it a
unique.
Thank you, I was doing that for every table since I started.
>2. Without foreign keys, your CREATE statements don't reveal table
relationships.
I am surprised, I thought my SQL is not a proper relationnal database
a
Damien,
1. If a column is a primary key, there is no need to declare it a unique.
2. Without foreign keys, your CREATE statements don't reveal table
relationships.
3. The best way I know to validate a schema is to (i) write or draw all the
application's use cases, (ii) from the use cases derive
# [EMAIL PROTECTED] / 2003-03-30 17:49:27 +0200:
> Hello, I was starting a php/mysql project in december and seeked for help on
> this mailing list, it has been a great help for solving problems.
> My application is a website where you can order meals from restaurants that
> are within your postcod
