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
