Re: PHPMYADMIN and Foreign Keys

2003-07-11 Thread Nils Valentin
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 yo

Re: PHPMYADMIN and Foreign Keys

2003-07-11 Thread Nils Valentin
Hi Brian, You understand that (at present) you will need to use Innodb tables if you want or already use Foreign key support ? O.K , just making sure you didn't miss that. I can give you only advice how to do it in the mysql command line client. Please login to the mysql command line client t

PHPMYADMIN and Foreign Keys

2003-07-11 Thread Brian Rivet
Hi Everyone, I'm using PHPMyAdmin to set up the database for a website, and I am trying to set up foreign keys between tables. I know that MySQL doesn't enforce them, but I want them there as part of the schema anyway. I tried executing the command to add the foreign key, it ran without any error