Upgrading to InnoDB tables
Hi, We have Mysql standard distribution (ver 3.23.32) for Solaris and we just realised that we needed InnoDB support. What would be the easiest way to add InnoDB table type? Is it possible to do it without affecting the tables and databases that are already present. thanks, Sanjay Chigurupati __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re InnoDb tables
Hi, does any1 know what is the earliest version of Mysql for Solaris, with support for InnoDB? If I am not mistaken, the version that we have is 3.23.32. Can MySql Max be added or some patch be added? This is not on a personal machine. It's on a server in my department (computer's science) and this is part of my project. thanks, Sanjay __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reg Foreign Key
Hi, Should I or shouldn't I explicitly specify the foreign key in Mysql? If I am not mistaken, Mysql handles foreign keys automatically at query time and we need not explicitly specify the foreign key. But, will the database detect error when I enter non-existent value for a foreign key? Do I need to explicitly specify foreign key when creating table? If I have to, can I use Alter table to modify table that has been already created? Thanks, Sanjay Chigurupati __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php