I tried on delete cascade, it didn't work either.
mysql> delete from samDB.license_info where licenseID=1;
Query OK, 1 row affected (0.01 sec)
mysql> select * from samDB.license_info;
Empty set (0.01 sec)
mysql> select * from samDB.license_data
-> ;
+-----------+------------+----------+------------+-----------+-----------+-----------+
| licenseID | logDate | totalLic | requestLic | issuedLic | queuedLic |
deniedLic |
+-----------+------------+----------+------------+-----------+-----------+-----------+
| 1 | 2002-01-11 | 1 | 1 | 1 | 1 |
1 |
+-----------+------------+----------+------------+-----------+-----------+-----------+
1 row in set (0.00 sec)
Jing
Paul DuBois wrote:
> At 15:12 -0800 12/11/02, Jing Dai wrote:
> >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.
>
> ON DELETE CASCADE is implemented, but ON UPDATE CASCADE is not.
---------------------------------------------------------------------
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
