After install mysql-max 3.23.52 and enable innodb setting in /etc/my.cnf
file, recreate table, this time
show create table indicated it's innodb type, but tried update on cascade
still not working.
Any idea?
mysql> create table samDB.license_info (
-> licenseID integer(5) auto_increment primar
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 configu
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,
-> fe
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 casca
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 (
://www.beridney.com
- Original Message -
From: "Jeff Tanner" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, September 11, 2001 9:13 AM
Subject: FOREIGN KEY ... ON DELETE CASCADE
> Is FOREIGN KEY ... ON DELETE CASCADE operational in m
Is FOREIGN KEY ... ON DELETE CASCADE operational in mysql?
If so, I am not observing such. Here is how I am using it:
CREATE TABLE scheduled_task_list (
schedule_id CHAR(28) NOT NULL,
/* keys */
PRIMARY KEY (schedule_id)
);
CREATE TABLE
