Re: Foreign keys in MySQL

2002-07-10 Thread Roger Baklund
* 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.

Re: foreign keys in mysql

2002-03-06 Thread Arjen Lentz
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, >