RE: foreign key creation on MyISAM storage engine

Hi thanks for the response.

Thus is I want full-text capabilities etc. that come with the MyISAM storage
I have to sacrifice foreign keys/referential integrity, which is something I
am uncomfortable with, what do other people do in this situation?
Do I create two tables one for the foreign keys/referential integrity and
one to perform the full-text on?


Kind regards,
 

Taco Fleur - CEO

Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an industry leader with commercial
IT experience since 1994 .

*	
	Web Design and Development 
*	
	SMS Solutions, including developer API
*	
	Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!


-----Original Message-----
From: [email protected] [mailto:[email protected]]

Sent: Sunday, 26 March 2006 7:18 PM
To: [email protected]
Subject: Re: foreign key creation on MyISAM storage engine

Taco,

If I remember rightly the reason you cannot create foreign keys on MyISAM
tables is because the MyISAM storage engine does not support foreign
keys/referential integrity.

If you want that kind of functionality I think you need to look at either
the InnoDB or BDB storage engines. I'm afraid I can't remember which one
you'll need as all of my stuff uses MyISAM so you'll have to do a bit more
research to find the right storage engine for your job.

I hope this helps

Best Regards


Chris.




"Taco Fleur" <[email protected]> on 26/03/2006 07:54:14

Please respond to <[email protected]>

To:    <[email protected]>
cc:

Subject:    foreign key creation on MyISAM storage engine


Hi all,

has anyone experienced any problems creating foreign keys (relationships) on
tables that are of storage engine MyISAM?

I can't seem to be able to create any relationships on those tables in MySQL
Administrator 1.1.8

Any help would be much appreciated.

Kind regards,


Taco Fleur - CEO

Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox
<http://www.pacificfox.com.au/> http://www.pacificfox.com.au an industry
leader with commercial IT experience since 1994 .

*

 Web Design and Development
*

 SMS Solutions, including developer API
*

 Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for
fifty dollars two years!









**********************************************************************
This transmission is confidential and must not be used or disclosed by
anyone other than the intended recipient. Neither Corus Group Plc nor any of
its subsidiaries can accept any responsibility for any use or misuse of the
transmission by anyone.
**********************************************************************




-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]