Re: weird innodb foreign key feature

2005-10-26 Thread Ady Wicaksono
r 26, 2005 9:25 AM Subject: weird innodb foreign key feature I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on RedHat Linux 9 and found this weird thing I create first table CREATE TABLE `t_keycode` ( `keycode_id` int(11) NOT NULL auto_increment, `keycode_val

Re: weird innodb foreign key feature

2005-10-26 Thread Heikki Tuuri
- Original Message - From: "Ady Wicaksono" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, October 26, 2005 9:25 AM Subject: weird innodb foreign key feature I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on RedHat Linux 9 and f

weird innodb foreign key feature

2005-10-25 Thread Ady Wicaksono
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on RedHat Linux 9 and found this weird thing I create first table CREATE TABLE `t_keycode` ( `keycode_id` int(11) NOT NULL auto_increment, `keycode_val` varchar(255) NOT NULL default '', `keycode_desc` varchar(255) NOT NULL defa