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
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
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