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 to execute the following programs. Use "SHOW INDEX FROM tblname;" to see all indexes specified. Use "SHOW CREATE tblname" to see the create statement for a table (including the indexes). I assume you are confortable on the command line, so I dont include the screen output here as it wraps rather ugly in an e-mail. Best regards Nils Valentin Tokyo/Japan 2003年 7月 11日 金曜日 22:59、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, but I don't see any indication that the foreign key exists as > part of the schema now. Is there a command either in PHPMyAdmin or MySQL > that will show me which fields are foreign keys, and where they point > to? I just want to make sure I set them up right. > > Thanks, > > Brian Rivet -- --- 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]
