Hi Brian, thats fine. You can always convert between the different table formats. As long as you know some rules there will be no data loss.
As mentioned at the present only innodb support foreign keys. That means that converting a innodb table f.e to another table format should either give you an error message or silently ignore the foreign keys. Anyway I suggest not experiencing not on the real data tables ( WOW - I guess you didnt new that ;-) - just wanted to make sure it's in the record ;-). You will have to setup all foreign keys by yourself, mysql will not do that for you automatically. I am unable at present to give any advice on the PHP side. Best regards Nils Valentin Tokyo/Japan 2003年 7月 11日 金曜日 23:41、Brian Rivet さんは書きました: > Hi Nils, > > I wasn't actually aware of this, but I don't plan to use MySQL to > enforce the foreign keys, I just want them there as part of the schema > in case the database needs porting to another system. I will do all of > the enforcement in PHP. I just wanted to see if it was actually setting > up the foreign key in the database somewhere. > > Thanks, > > Brian -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]