Upgrading to InnoDB tables

2002-03-14 Thread Sanjay Chigurupati
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

Re InnoDb tables

2002-03-12 Thread Sanjay Chigurupati
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)

Reg Foreign Key

2002-03-07 Thread Sanjay Chigurupati
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