ANN: Hopper (stored procedure debugger), version 1.0.3 released
ANN: Hopper, version 1.0.3 released Dear ladies and gentlemen, Upscene Productions is proud to announce version 1.0.3 of our product called Hopper. Hopper is a Windows-based Stored Routine and Trigger Debugger, available for InterBase, Firebird and MySQL. This version fixes an imporant 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 To unsubscribe:http://lists.mysql.com/mysql
boleto
- 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 42031789 Prezado(a) se encerra em 10/08/2012 está disponível para pagamento. Para visualizá-lo, basta clicar no botão abaixo. Para informações detalhadas da sua fatura, acesse a área restrita no site www.cordiaip.com.br informando o número de sua conta (49031789) e senha. Obrigado novamente por escolher a Cordia Comunicações S/A. Atenciosamente, Serviço de Atendimento ao Cliente Para contato via telefone ou email, por favor visite a secção Contato em nosso website www.cordiaip.com.br Observe que você não pode responder diretamente esse email. Se você tem alguma dúvida sobre sua conta ou se necessitar de auxílio, por favor entre em contato com o Serviço de Atendimento ao Cliente da Cordia Comunicações S/A. © Copyright 2012, Cordia Comunicações S/A, Inc. Todos direitos reservados.
RE: query help
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: MySQL Subject: Re: query help 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 stores half string half number like strings in it. Example shop.orders.32442 the syntax is DATABASENAME.TABLENAME.RECID My goal is to scan this col and find out the biggest RECID ( the integer) in it. So, in a case like this shop.orders.32442 shop.orders.82000 shop.orders.34442 It would be the record whose source_recid is shop.orders.82000. Why? Cause 82000 happens to be the largest integer. What SQL statement would get me that record? One option to this is to create a new column ( the_ids ) and move all the integers in it and then run something like this select source_recid from mytable where source_recid like 'shop.orders.%' order by the_ids DESC LIMIT 1 Is there a way to pull this off without going thru this step? Would substring work? SELECT SUBSTRING(recid, 13, column size) AS numbers FROM table ORDER BY numbers DESC -- Paul Halliday http://www.pintumbler.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: How often the slave to pull data from master?
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 created a separate cache specifically for the non-transacted events to reduce our replication overhead. Only those statements will be transmitted in the event of a ROLLBACK. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
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 getting it so that we can write an sql query to do this. So for all practical purposes on my end, the question is being resolved. But I don't understand how clicking the icon after running a select query works for exporting, but the command to outfile in a sql query would not work. Thanks again On Tue, Jul 31, 2012 at 5:36 AM, Michael Widenius mo...@askmonty.orgwrote: Hi! Fred == Fred G Fred writes: Fred Thanks Dhaval. Putting the join condition before INTO outfile doesn't seem Fred to work, either. Fred When I try to use the same outfile name 'test123.csv' I get Error Code: Fred 1086 File 'test123.csv' already exists. But then when I try to find the Fred csv file on my computer, there is a folder with that name, but weird files Fred in it, none of which are a csv-- and certainly not in the location that I Fred thought it would be (the same directory that the .sql query is in). It's the mysqld server that is writing the .csv file. This means that the path is related to the mysql data directory and not to where your .sql file is. When using select into outfile it's always best to give a full path! Fred Additionally, when I try to identify a different path, such as 'C:\\' etc, Fred I get an error. This error is: Error Code: 1. Can't create/write to file Fred C:\test123.csv(Errocde: 2). This probably means that you don't have write access to C:\ Fred I tried running the query outputting to a different named .csv file, but it Fred is still just running... and seems like it was like yesterday where after Fred 10 minutes I will get the Error that the MySQL connection was lost. The reason that your connection is lost are ether: - There is timeout in the client you are using (The server never gives a timeout for running queries). - The mysqld server died (not likely but possible). - Some process in your system is killing quries that runs too long. One way to quickly check that things are working are by adding LIMIT 1 to the query. Fred Does anyone have an idea of what is going on? The query without exporting the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). What is the exact error message? Which client are you using to do the query? It's strange that the query works fine when you are not using select into outfile. What MySQL version are you using Regards, Monty Creator of MySQL and MariaDB
Re: How often the slave to pull data from master?
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 as they are executed. We track them in this cache for replication purposes. Are you worried about a race between a crash and the time where the cache is applied to the main binary logs? This is a very unlikely event for two reasons: 1) the non-transacted change must occur within a transaction 2) most users that use transactions only use transaction-enabled storage engines (InnoDB). So in order to lose non-transacted changes from a crash that happens before the cache is appended to the binary log, you must a) have a sequence of statements (or ROW-based changes) that is smaller than --binlog-cache-size limit b) have a mixed-mode transaction. If this is a valid concern for your usage pattern set --binlog-cache-size to a smaller value. http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_binlog_cache_size -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: How often the slave to pull data from master?
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 RBR.) -Original Message- From: Shawn Green [mailto:shawn.l.gr...@oracle.com] Sent: Wednesday, August 01, 2012 12:07 PM To: Rick James Cc: David Lerer; Zhigang Zhang; mysql@lists.mysql.com Subject: Re: How often the slave to pull data from master? 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 as they are executed. We track them in this cache for replication purposes. Are you worried about a race between a crash and the time where the cache is applied to the main binary logs? This is a very unlikely event for two reasons: 1) the non-transacted change must occur within a transaction 2) most users that use transactions only use transaction-enabled storage engines (InnoDB). So in order to lose non-transacted changes from a crash that happens before the cache is appended to the binary log, you must a) have a sequence of statements (or ROW-based changes) that is smaller than --binlog-cache-size limit b) have a mixed-mode transaction. If this is a valid concern for your usage pattern set --binlog-cache- size to a smaller value. http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary- log.html#sysvar_binlog_cache_size -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: query help
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 stores half string half number like strings in it. Example shop.orders.32442 the syntax is DATABASENAME.TABLENAME.RECID My goal is to scan this col and find out the biggest RECID ( the integer) in it. So, in a case like this shop.orders.32442 shop.orders.82000 shop.orders.34442 It would be the record whose source_recid is shop.orders.82000. Why? Cause 82000 happens to be the largest integer. What SQL statement would get me that record? One option to this is to create a new column ( the_ids ) and move all the integers in it and then run something like this select source_recid from mytable where source_recid like 'shop.orders.%' order by the_ids DESC LIMIT 1 Is there a way to pull this off without going thru this step? Would substring work? SELECT SUBSTRING(recid, 13, column size) AS numbers FROM table ORDER BY numbers DESC -- Paul Halliday http://www.pintumbler.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
create roles/groups in MYSQL
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?
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 [mailto:vegiv...@tuxera.be] Sent: Tuesday, July 31, 2012 1:39 AM To: Incarus Derp Cc: mysql@lists.mysql.com Subject: Re: how to replace this data in a complex field? - Original Message - From: Incarus Derp icarusd...@gmail.com I have a complex field named Inventory in a table named Table1 that can be different every time and is not guaranteed to contain what I need to replace. [[Thing1,Thing4,thing8,thing1,thing942,ACRE_PRC119_ID_29], [[thing1700,2],datthing4,pizza,water,apples,beans,coke-a- c ola,rice,apples,apples,icecream,pizza,[7things,6],7thing s,7things,8things,tophats,tophats,762x39mmRU]] That looks more like a multidimensional array than a table, to me. I need to replace ACRE_PRC119_ID_29 with ACRE_PRC119 and I cannot do this externally. I have PREG_REPLACE but I'm not sure how I would apply this to the database because it only SELECT's as far as I know. ...and preg_replace is a PHP function, not a MySQL one. Are you sure you're on the right list? In any case, if you're looking to do this in MySQL, this is the function you're probably going to be using: http://dev.mysql.com/doc/refman/5.0/en/string- functions.html#function_replace If you're looking to do those substitutions on an mdarray in PHP, well, wrong list :-) I'll hint you that you're probably going to have to write a recursive function, though, if your mdarray has varying depth. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: create roles/groups in MYSQL
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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql