Hi all I have problem in MYSQL query browser tool. I make a two tables ,one have primary key, and in second table i put reference to first table. I make all this in Query browser and set foreign key of second table to on delete no action. I apply changes but next time when i want to edit second table i see that foreign key is set to on delete restrict, and i don`t know way? In MYSQL Admin Tool i gave user all privileges to that database which contains two tables. Database is INNODB type.
I want to make that foreign key set to on delete no action but i can`t do it . Any idea how to make it in MySQL query browser tool? 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]