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 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]
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 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]
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. 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]
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 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]
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 default '0', `GrupaID` int(10) unsigned NOT NULL default '0', `PodgrupaID` int(10) unsigned NOT NULL default '0', `DatumZaduzenja` date NOT NULL default '-00-00', `DatumRazduzenja` date default NULL, `DatumUrgencije` date default NULL, `Komentar` text, TABLE `predmet_referent` ( `PredmetID` int(10) unsigned NOT NULL default '0', `VrstaPredmetaID` int(10) unsigned NOT NULL default '0', `KorisnikID` int(10) unsigned NOT NULL default '0', `GrupaID` int(10) unsigned NOT NULL default '0', `PodgrupaID` int(10) unsigned NOT NULL default '0', `ReferentID` int(10) unsigned NOT NULL default '0', which reference all from table predmet and CREATE TABLE `referent` ( `ReferentID` int(10) unsigned NOT NULL auto_increment, `SifraReferenta` varchar(2) NOT NULL default '', `ImeReferenta` varchar(30) NOT NULL default '', `PrezimeReferenta` varchar(45) NOT NULL default '', PRIMARY KEY (`ReferentID`) My table predmet_referent looks like this PredmetID VrstaPredmetaID KorisnikID GrupaID PodgrupaID ReferentID 1, 1, 18, 4, 4, 1 1, 1, 18, 4, 4, 2 2, 1, 21, 6, 3, 2 2, 1, 21, 6, 3, 3 3, 1, 22, 5, 1, 2 3, 1, 22, 5, 1, 1 3, 1, 22, 5, 1, 3 4, 3, 23, 6, 3, 1 4, 3, 23, 6, 3, 2 4, 3, 23, 6, 3, 3 and table referent looks like ReferentID SifraReferenta ImeReferenta PrezimeReferenta 1, '01', 'Nada', 'Nadić' 2, '03', 'Goran', 'Gavrančić' 3, '04', 'Dragan', 'PeriÅ¡ić' I want to make select query so thatt result from that query look something like this PredmetID BrojPredmeta Referent1 Referent2 Referent3 1 121215 12 2 121355 23 3 236564 21 3 4 213545 12 3 How can i do this?This is very importat for me Any help will be great. __ 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]
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 ,đ,č,ć, character date in database directly from MySQL Query tool and and display that data in jsp pages i see all character ok, but when i use jsp pages to insert č,đ,,ć character and want to display them i got some strange characters. Also i put my IE browser to UNICODE UTF8 encoding. How can i see correct ,ć,đ,,č in my browser correct? 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]