Re: primary/foreign key contraints

2002-09-03 Thread David Lloyd 


Neal,

> Sorry for the MySQL newbie question ... but are there not primary/foreign
> key constraints in MySQL 3?

In MyISAM tables or ISAM tables no.

> I can't imagine that this is right.  Perhaps
> I'm just overlooking something

innodb?

(mysql query)

DSL

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: primary/foreign key contraints

2002-09-03 Thread Victoria Reznichenko 

neal,
Tuesday, September 03, 2002, 4:06:37 AM, you wrote:

n> Sorry for the MySQL newbie question ... but are there not primary/foreign
n> key constraints in MySQL 3?  I can't imagine that this is right.  Perhaps
n> I'm just overlooking something

Foreign keys constraints is supported in InnoDB tables:
http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
http://www.mysql.com/doc/en/SEC447.html




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

primary/foreign key contraints

2002-09-02 Thread neal 

Sorry for the MySQL newbie question ... but are there not primary/foreign
key constraints in MySQL 3?  I can't imagine that this is right.  Perhaps
I'm just overlooking something

Thanks.
Neal


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php