MYSQL-on cascade no action

2006-06-07 Thread Nenad Bosanac
Hi all
I have problem in MYSQL query tool.
Well i put on foreign key on cascade no action
but next time when i edit that table
it said that is on cascade is restrict.
Why is that ?
I use  MYSQL Query tool and my database is 
INNODB.
Is there some kind of way to make it work
or it is some kind of default value for 
innodb type of database?
Thanks

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: MYSQL-on cascade no action

2006-06-07 Thread Jo�o C�ndido de Souza Neto
I´ve never seen on cascade no action, you want to say on delete cascade or 
something like this?

Nenad Bosanac [EMAIL PROTECTED] escreveu na mensagem 
news:[EMAIL PROTECTED]
 Hi all
 I have problem in MYSQL query tool.
 Well i put on foreign key on cascade no action
 but next time when i edit that table
 it said that is on cascade is restrict.
 Why is that ?
 I use  MYSQL Query tool and my database is
 INNODB.
 Is there some kind of way to make it work
 or it is some kind of default value for
 innodb type of database?
 Thanks

 __
 Do You Yahoo!?
 Tired of spam?  Yahoo! Mail has the best spam protection around
 http://mail.yahoo.com 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]