ANN: Hopper (stored procedure debugger), version 1.0.3 released

2012-08-01 Thread Martijn Tonies
error with the MySQL version, amongst other small issues. For more information, see http://www.upscene.com/displaynews.php?item=20120801 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

boleto

2012-08-01 Thread Cordia Comunicações
- This mail is in HTML. Some elements may be ommited in plain text. - Para garantir que os emails provindos da Cordia Comunicações S/A estão sendo entregues corretamente em sua caixa de email, por favor configure seu filtro de email para aceitar emails de cordiaip.com. Email número de conta

RE: query help

2012-08-01 Thread Rick James
Might need some type coercion: SELECTSUBSTRING(recid, 13, column size) AS numbers FROM table ORDER BY SUBSTRING(recid, 13, column size)+0 DESC -Original Message- From: Paul Halliday [mailto:paul.halli...@gmail.com] Sent: Tuesday, July 31, 2012 3:27 PM To: Haluk Karamete Cc:

RE: How often the slave to pull data from master?

2012-08-01 Thread Rick James
That leads to another question... Does this 'separate cache' contain an extra copy (vs the 'only' copy) of the non-transacted events? I would expect that it must be an extra copy. -Original Message- From: Shawn Green [mailto:shawn.l.gr...@oracle.com] ... Beginning with 5.5.9, we

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-08-01 Thread Fred G
Hi Monty, First of all, thanks so much for responding to my question! I am using MySQLworkbench 5.2.37CE. I'm pretty sure the issue has to do with something on the administrator side of things. We managed to get it so that I can click the icon to export the file, but he's still working on

Re: How often the slave to pull data from master?

2012-08-01 Thread Shawn Green
On 8/1/2012 1:13 PM, Rick James wrote: That leads to another question... Does this 'separate cache' contain an extra copy (vs the 'only' copy) of the non-transacted events? I would expect that it must be an extra copy. No. The non-transacted events are applied to the tables they belong to

RE: How often the slave to pull data from master?

2012-08-01 Thread Rick James
BEGIN; UPDATE Inno_tbl SET x = 100; INSERT INTO Myisam_tbl SELECT x FROM Inno_tbl; UPDATE Inno_tbl SET x = 200; INSERT INTO Myisam_tbl SELECT x FROM Inno_tbl; COMMIT; To get the right values in Myisam_tbl, the transacted and non-transacted commands must be interleaved. (I am assuming SBR, not

Re: query help

2012-08-01 Thread Vikas Shukla
Hi, Use LIMIT 1 to limit the number of output to single record. Regards, Vikas Shukla On Wed, Aug 1, 2012 at 3:56 AM, Paul Halliday paul.halli...@gmail.comwrote: On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete halukkaram...@gmail.com wrote: I've got a text field called source_recid. It

create roles/groups in MYSQL

2012-08-01 Thread Aastha
Hello, I have 10 different users and i have to give different accesses to different tables. Is it possible to create a groups with different set of access rights on different tables. I know there are ROLES and PROFILES in Oracle. Is there something similar in MySQL. Thanks, Aastha Gupta

RE: how to replace this data in a complex field?

2012-08-01 Thread Rick James
In other words, this might work?? UPDATE Table1 SET Inventory = REPLACE(Inventory, 'ACRE_PRC119_ID_29', 'ACRE_PRC119'); Note: the extra quotes were deliberate. If it is not always ID_29, then the problem is more difficult. -Original Message- From: Johan De Meersman

RE: create roles/groups in MYSQL

2012-08-01 Thread Rick James
Sorry, nothing like Roles or Profiles. Copy Paste. -Original Message- From: Aastha [mailto:aast...@gmail.com] Sent: Wednesday, August 01, 2012 1:56 PM To: mysql@lists.mysql.com Cc: Aastha Subject: create roles/groups in MYSQL Hello, I have 10 different users and i have to