tag:blogger.com,1999:blog-15319370.post113329846258899979..comments2024-03-05T11:16:00.846+01:00Comments on Roland Bouman's blog: This is TOO Wicked!rpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-15319370.post-2444365675537179962007-07-05T23:23:00.000+02:002007-07-05T23:23:00.000+02:00Murali, the links are right there in my comment. R...Murali, <BR/><BR/>the links are right there in my comment. Read them, all the information you need to get started is there.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-56405903911004951152007-07-05T22:44:00.000+02:002007-07-05T22:44:00.000+02:00Oh... really good one .But i want to know how to i...Oh... really good one .<BR/>But i want to know how to install that to my system..<BR/><BR/><BR/>Thanks for the responseMurali.Vhttps://www.blogger.com/profile/17404063184457856697noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-84783580287433930872007-07-05T21:49:00.000+02:002007-07-05T21:49:00.000+02:00Murali, MySQL does not have DDL triggers like Orac...Murali, <BR/><BR/>MySQL does not have DDL triggers like Oracle. But there is a very cool new development going on, MySQL Proxy. <BR/><BR/>Go get it here: http://dev.mysql.com/downloads/mysql-proxy/0.5.html<BR/><BR/>and Read all about it here:<BR/>http://forge.mysql.com/wiki/MySQL_Proxy<BR/><BR/>With MySQL Proxy you should be able to intercept any query fired to MySQL, and act upon it. <BR/><BR/>That said - if you just want to prevent people chucking stuff away, just don't give them the privilege to do so. Create a separate user for each particular physical user and give them privileges accordingly.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-7867117010162551182007-07-05T18:39:00.000+02:002007-07-05T18:39:00.000+02:00Hi,I want to know one thing, i have a database whi...Hi,<BR/><BR/>I want to know one thing, i have a database which contains few tables and few default records in that. <BR/><BR/>Sometimes unusually some developer is truncating the tables or else dropping the table without my knowlege. <BR/><BR/>How can i track these changes in my database? <BR/><BR/>Any answers will be most welcome and useful for me. <BR/><BR/>In Oracle, i heard that there are DDL and DML Triggers available but iam new to MYSQL. can anyone tell me is that any functionality available in MYSQL?Murali.Vhttps://www.blogger.com/profile/17404063184457856697noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-22237412599899509252007-01-09T12:02:00.000+01:002007-01-09T12:02:00.000+01:00Hi there,
> Sorry but implementing DECODE is a wa...Hi there,<br /><br />> Sorry but implementing DECODE is a waste of time, it's non standard and<br />> Oracle versions higher than 8i support the standard CASE construct. <br /><br />I know that - the point is that there might be an application that uses it, and that replacing DECODE with `DECODE` in your migration process might be a little easier than rewriting it as a CASE statement.<br /><br />Of course, I agree that adherering to a standard is usually a good idea. I started using CASE too in Oracle, and I really think there's not much benefit in using DECODE anymore (although I haven't tried to see if there is some difference in performance - I suspect it would be very small or absent)rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-40295920451863237042007-01-09T11:07:00.000+01:002007-01-09T11:07:00.000+01:00Sorry but implementing DECODE is a waste of time, ...Sorry but implementing DECODE is a waste of time, it's non standard and Oracle versions higher than 8i support the standard CASE construct.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1133375815913299642005-11-30T19:36:00.000+01:002005-11-30T19:36:00.000+01:00Hey, everyone, thanks for your kind comments.Mike ...Hey, everyone, thanks for your kind comments.<BR/><BR/>Mike (Whoops! I wonder who else I forgot to mention, sorry!), I most probably will attend. I'll might take a week off, or else I might get my employer to sponsor, we'll see. I'm looking very much forward to see you too there, as well as the rest of the team.<BR/><BR/>Jay, well on some of the lists, that might be true, but I know when to speak up and when to shut up (..well...). For instance, on the performance forum, I'm just a humble observer, seeing you and Felix cracking those problems, and solving them more often than not. <BR/><BR/>Hey Beat, just teasing man. Actually, your blog shows up quite decent on IE. I mean, the important things are all there: I can read the articles, and post comments, so what more can you possibly want. <BR/><BR/>CU, and thanks againrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1133309953236297402005-11-30T01:19:00.000+01:002005-11-30T01:19:00.000+01:00Congratuations, Roland! You certainly deserve the...Congratuations, Roland! You certainly deserve the recognition. You know, Felix and I barely have a chance to answer any forum questions anymore, because you "buzz in" too quickly! Congrats again! ;)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1133300512650373112005-11-29T22:41:00.000+01:002005-11-29T22:41:00.000+01:00Congratulations Roland, I look forward to seeing y...Congratulations Roland, I look forward to seeing you at the User Conference!Anonymousnoreply@blogger.com