restrict and no action problem

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

MYSQL Query Browser 1.1.20 problem

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

MYSQL-on delete no action

Hi all I made mistake i n my last post so now i make it true. I have problem in MYSQL query tool. Well i put on foreign key on delete no action but next time when i edit that table it said that is on delete is restrict. Why is that ? I use MYSQL Query tool and my database is INNODB.

MYSQL-on cascade no action

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

Select query problem

Hi I have one problem that i can`t resolve. I have 3 tables TABLE `predmet` ( `PredmetID` int(10) unsigned NOT NULL auto_increment, `BrojPredmeta` int(10) unsigned NOT NULL default '0', `VrstaPredmetaID` int(10) unsigned NOT NULL default '0', `KorisnikID` int(10) unsigned NOT NULL

Problems with UTF and MySQL

I have problem with UTF-8 character set. I use MySQL 5 and Tomcat 5.5.9.I use NetBeans for programinnig in Java. I made one database and is in UTF8,also all my JSP pages are set to UTF8 encoding,and also all HTML are set to UTF8. When i put š,#273;,#269;,#263;,ž character date in database