Seems each new developer in our group does it once in their first month of using SQL. Twice in one week - ouch.
Good luck, Tom -----Original Message----- From: Kevin Fricke [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 7:42 PM To: [email protected] Subject: RE: mySql 5.0 nope...but still hurts ;) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matt Woodward Sent: Wednesday, August 24, 2005 9:36 PM To: [email protected] Subject: Re: mySql 5.0 Ouch--unfortunately there's nothing globally you can do to stop that. You *can* control specific rights in the datasource configuration for a particular user (e.g. limit to selects only) but if they have update rights, they can be dumb and do this. The only way to stop it is code reviews I suppose, and for the love of god I hope you aren't letting the newbies hit your production database directly. ;-) Matt On 8/24/05, Kevin Fricke <[EMAIL PROTECTED]> wrote: > Thanks for the info! > > Another question. Does anyone know a way to set up cf so that if you > run an > update query without a where it will error out? I have some new help > and this has happened twice in the last week. Open ended queries > updated the whole database...not good ;) > > kevin > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Adrian J. Moreno > Sent: Wednesday, August 24, 2005 9:24 PM > To: [email protected] > Subject: Re: mySql 5.0 > > > You think SQL Server's expensive, I'm trying to ditch Oracle. I've > been using the 64-bit version of MySQL 4.x in production (dual > Opteron) for almost a year and I've no doubt Oracle and MS are > sweating bullets right about now. > > Their August 2005 Newsletter came out today: > > --------------------------------------------------------------- > Products > New Release of MySQL (5.0.11 Beta) is Now Available > > This Beta release in a pre-production release in the 5.0 series. This > release includes support for Stored Procedures, Views, Triggers, > Information Schema (Data Dictionary), XA and more. Additional updates > include: > > - Security improvement: Applied a patch that addresses a potential > zlib data vulnerability that could result in an application crash. > This only affects the binaries for platforms that are linked > statically against the bundled zlib (most notably Microsoft Windows > and HP-UX) > - Mysqldump now dumps triggers for each dumped table. This can be > suppressed with the –skip-triggers option. > - Added an optimization that avoids key access with NULL keys for the > ref method when used in outer joins. > - Numerous bug fixes > > *All efforts are now being focused on fixing bugs and stabilizing > MySQL 5.0 for the upcoming production release. Get a head start on > your projects by testing MySQL 5.0 beta now.* > ----------------------------------------------------------------- > > Hopefully it'll hit GA around October. I know someone who writes their > documentation, but he won't even give me an "I heard" date. > > -- Adrian > > > Kevin Fricke wrote: > > that would save some serious $$. > > > > Thats what I am waiting for... > > > > Kevin > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Behalf Of Matt Woodward > > Sent: Wednesday, August 24, 2005 6:03 PM > > To: [email protected] > > Subject: Re: mySql 5.0 > > > > > > Haven't heard anything specific but I'm anxiously awaitin this one > > as well. It might mean I can dump SQL Server in some cases. > > > > Matt > > > > On 8/24/05, Kevin Fricke <[EMAIL PROTECTED]> wrote: > > > >> > >>Anyone heard when the expected release of 5.0 is? > >> > >>Kevin > > > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com NŠ²Û×j)¢Xµ×qû¢¸¢é¹»®&†ÛÿüÁ×qû¢¸~Š1ézµ²ær¸yÇN‹nlj·¶Úÿ uü~订¹zfŠËjØÇ ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
