Ok, I found answer, I did need uncomment out my.cnf to support InnoDB type. Also I need to install mysql-max binary as I am running on Unix Platform.
jing Jing Dai wrote: > Hi, > Thank you for the reply. > I did what you suggested, but show create table is still MYISM, why? > Do I need to configure something in the my.cfn file? > > mysql> create table samDB.license_info ( > -> licenseID integer(5) auto_increment primary key, > -> vendorName VARCHAR(30) NOT NULL, > -> featureName VARCHAR(30) NOT NULL, > -> comment VARCHAR(100)) TYPE=INNODB; > Query OK, 0 rows affected (0.02 sec) > > mysql> show create table samDB.license_info; > >+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > > | Table | Create Table > > | > >+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > > | license_info | CREATE TABLE `license_info` ( > `licenseID` int(5) NOT NULL auto_increment, > `vendorName` varchar(30) NOT NULL default '', > `featureName` varchar(30) NOT NULL default '', > `comment` varchar(100) default NULL, > PRIMARY KEY (`licenseID`) > ) TYPE=MyISAM | > >+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > > Jing > Benjamin Pflugmann wrote: > > > Hello. > > > > On Tue 2002-12-10 at 16:05:05 -0800, [EMAIL PROTECTED] wrote: > > > I am just working on mySQL and create two tables, defined licenseID is > > > the primary key in license_info, and foreign key in license_data. > > > But I tested it didn't work the way as like in Oracle delete cascade or > > > update cascade. > > > Did I do something incorrect? > > > > > > mysql> create table samDB.license_info ( > > > -> licenseID integer(5) auto_increment primary key, > > > -> vendorName VARCHAR(30) NOT NULL, > > > -> featureName VARCHAR(30) NOT NULL); > > > Query OK, 0 rows affected (0.01 sec) > > > > If you did not change your default table type, this will create a > > table with the MYISAM handler. You can find that out by using SHOW > > CREATE TABLE samDB.license_info. ON CASCADE is only supported with the > > InnoDB handler. You can force the InnoDB handler by adding TYPE=InnoDB > > before the semicolon in the query above. > > > > HTH, > > > > Benjamin. > > > > -- > > [EMAIL PROTECTED] --------------------------------------------------------------------- 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
