Foreign keys in MySQL 5.0

Hi all! Looking at one of the things that is set to be added to MySQL 5.0 (foreign keys for all table types), I have the following question: Will we be able to have foreign keys that involve tables of different types? Any early indications about the performance implications of having such things

RE: Primary and Foreign Keys in MySQL

Message- > From: Aamer Rauf [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 12:55 PM > To: [EMAIL PROTECTED] > Subject: Primary and Foreign Keys in MySQL > > > Hello, > > I am working on MySQL database. I have come across a 'problem' > but don&

Primary and Foreign Keys in MySQL

Hello, I am working on MySQL database. I have come across a 'problem' but don't know how to get around that. The problem is the following: I have a table, say TABLE1, with primary key being called as table1_id. Now there are other tables, like TABLE1A, TABLE1B, TABLE1C etc.. where I want to us

Re: Foreign keys in MySQL

* Hanxue Lee > In the MySQL documentation, it is stated that > > "foreign keys in SQL are not used to join tables, but are used mostly for > checking referential integrity (foreign key constraints). " This could have been formulated in a better way, IMHO. I would even say the statement is wrong.

Foreign keys in MySQL

Hi, In the MySQL documentation, it is stated that "foreign keys in SQL are not used to join tables, but are used mostly for checking referential integrity (foreign key constraints). " Does it mean that constraints are not supported? I need to have Update and perhaps Delete Referential Integrity

Help - foreign keys in MySQL-Max-4.0.1

Hi, I use MySQL-Max-4.0.1 and i am wantering if the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you. --

FW: foreign keys in MySQL-Max-4.0.1

-Original Message- From: victoria papazoi [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 11:58 AM To: [EMAIL PROTECTED] Subject: foreign keys in MySQL-Max-4.0.1 Hi, I use MySQL-Max-4.0.1 and i am wantering if the information about the foreign keys are stored at comment

foreign keys in MySQL-Max-4.0.1

Hi, I use MySQL-Max-4.0.1 and i am wantering if the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you.

foreign keys in MySQL-Max-4.0.1

Hi, I use MySQL-Max-4.0.1 and i am wantering if is true that the information about the foreign keys are stored at comment properties of table with maximum length 60 characters? I need to use innodb tables with many f.keys.What I have to do? Thank you. -

Re: foreign keys in mysql

Hi, On Thu, 2002-03-07 at 08:20, bin cai wrote: > I am encountering one problem. I am using mysql as the > dabase for my application. > I create a table like takeexam as following:create > table takelabexam( sid varchar(10) not null, > cid varchar(20) not null, >