Re: InnoDB Foreign Key Questions

2003-01-16 Thread Heikki Tuuri
Muhammed, - Original Message - From: Muhammed Syyid [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, January 16, 2003 3:06 PM Subject: Re: InnoDB Foreign Key Questions Second the same question :). What does the CONSTRAINT keyword regarding FOREIGN KEYS do

InnoDB Foreign Key Questions

2003-01-13 Thread Karam Chand
Hello I have two tables of InnoDB type. CREATE TABLE `ledger` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, PRIMARY KEY (`id`), KEY `id` (`name`) ) TYPE=InnoDB; CREATE TABLE `voucher` ( `id` int(11) NOT NULL default '0', `vdate` date NOT NULL default