UPDATE and simultaneous SELECT ... similar to RETURNING?

All, There was a feature of another DB that I have grown extremely accustomed to and would like to find the equivalent in MySQL: UPDATE mytable SET mycolumn = mycolumn + 1 WHERE mykey = 'dante' RETURNING mycolumn; The magic of this statement is in the "RETURNING" clause. RETURNING causes ever

Free online training class on MySQL backups and recovery.

Hey everyone, I just posted new blog post about an online training class I will be doing January the 13th. This class will cover backups, recovery and disaster planning. It is completely free with no strings attached. If you are interested, take a look at the blog post here: http://www.paragon-cs.

Re: mysql load balancing

Hi, El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón escribió: > 2009/12/21 Miguel Angel Nieto : >> Hi, >> >> I am searching fot a Mysql Load Balacing tool. I read about mysql >> proxy, sqlrelay, haproxy... >> >> What do you prefer? > > Hi, > > The solutions I have heard most from our cu

Re: Error in running trigger

please run this and lets us know the output show grants on root1; On Tue, Dec 22, 2009 at 5:50 PM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Ranjan, > > User doesn't have sufficient privileges. root access required. > > Thanks, > Krishna > > On Tue, Dec 22, 2009 at 3:26 PM,

Re: Error in running trigger

Hi Ranjan, User doesn't have sufficient privileges. root access required. Thanks, Krishna On Tue, Dec 22, 2009 at 3:26 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Hi, > > I have created the below trigger from root user with definer: > > CREATE definer=`*root...@`` TRIGGER `C

Re: Error in running trigger

is it root or root1 user. Also is this trigger executed by root user or some other user. On Tue, Dec 22, 2009 at 3:26 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Hi, > > I have created the below trigger from root user with definer: > > CREATE definer=`roo...@`` TRIGGER `CONSUM

Error in running trigger

Hi, I have created the below trigger from root user with definer: CREATE definer=`roo...@`` TRIGGER `CONSUMER_PROFILE_before_delete` BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW begin INSERT INTO DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERPRISE_URL_ID,CONSUMER_FIRST_NAME,CON

sql tuning

Hi All, I have below sql, the sql is quite big. select this_.listingprog_id as listingp1_490_3_, this_.marketplace_id as marketpl2_490_3_, this_.company_id as company3_490_3_, this_.listing_id as listing4_490_3_, this_.marketplace_listing_id as marketpl5_490_3_, this_.processing_flag as processin

Re: Spatial extensions

Hi Gavin, OK, I finally tracked down the source of the trouble... My CREATE TABLE query included a regular KEY index instead of SPATIAL KEY -- that's why the MBRCONTAINS wasn't working... Works now!! Thanks for your help. On 2009-12-22, at 2:42 AM, Gavin Towey wrote: > How did you populate th

Re: mysql load balancing

2009/12/21 Miguel Angel Nieto : > Hi, > > I am searching fot a Mysql Load Balacing tool. I read about mysql > proxy, sqlrelay, haproxy... > > What do you prefer? Hi, The solutions I have heard most from our customers (in production) are not mysql-specific: 1) Simple, not load-aware *DNS balancin