MySQL University session on March 5: Good Coding Style

2009-03-02 Thread Stefan Hinz
Good Coding Style http://forge.mysql.com/wiki/Good_Coding_Style This Thursday (March 5th, 14:00 UTC), Konstantin Osipov will give a MySQL University session on Good Coding Style. Konstantin is the lead of the server runtime environment team, and has been around at MySQL since 2003. For MySQL Univ

Ofertas em Higiêne Bucal

2009-03-02 Thread Dentista
Use o código de desconto NOSSOSITE  e receba 10% de desconto em todas as suas compras Temos os melhores preços do Mercado.  Se você encontrar um preço menor não faremos o mesmo preço. Você esta recebendo este por causa da sua relação com Gemas Brasil . Por favor confirme o seu interesse em rec

MySQL Binary Log Summary Tool

2009-03-02 Thread Claudio Nanni
All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there is

MySQL Binary Log Summary Tool - w/link!

2009-03-02 Thread Claudio Nanni
All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there is

10 times faster MySQL

2009-03-02 Thread Hugo Kohmann
New versions of Dolphin Express SuperSockets include support for accelerated loopback device / accelerated local communication. The solution provides 10 times less latency and 6 times higher throughput than standard Linux. Running the DBT2 benchmark/MySQL on a single node gives 10 times more tran

Marmaris Değirmenyanında görkemli ikiz villa

2009-03-02 Thread Eritre Danışmanlık
Aydoğan Normal Aydoğan 2 1 2009-02-24T12:56:00Z 2009-02-24T12:56:00Z 1 111 638 5 1 748 12.00 Clean Clean false 21 false false false TR X-NONE X-NONE MicrosoftInternetE

Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
Error: Duplicate entry '0' for key 'PRIMARY'   how can i fix it ?

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
How do I modify the column to add value? Can I do it with phpmyadmin? --- On Mon, 3/2/09, Gary Smith wrote: From: Gary Smith Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY' To: samc...@yahoo.com, mysql@lists.mysql.com Date: Monday, March 2, 2009, 1:58 PM Easy. Ensure that all in th

&& vs AND

2009-03-02 Thread Daevid Vincent
Someone sent me a huge SQL query today that used "&&" instead of "AND" all over the place. I was a bit surprised that it is legal mySQL, but I was always under the impression that is not proper. Can anyone confirm or deny this? Like will ALL SQL RDBMS support that syntax? http://dev.mysql.com/doc/

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
Are you talking about Length/Values1 --- On Mon, 3/2/09, Gary Smith wrote: From: Gary Smith Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY' To: samc...@yahoo.com, mysql@lists.mysql.com Date: Monday, March 2, 2009, 1:58 PM Easy. Ensure that all in the primary key have unique values.

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread Darryle Steplight
Are you trying to do an Insert On Duplicate Key? Do ou want to insert a new row if it doesn't already exist or update one if it does? On Mon, Mar 2, 2009 at 4:09 PM, sam rumaizan wrote: > Are you talking about Length/Values1 > > > > --- On Mon, 3/2/09, Gary Smith wrote: > > From: Gary Smith > S

RE: && vs AND

2009-03-02 Thread Martin Gainty
there is no && character matrix supported in the SQL92 spec located at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt also there is no Truth Table for && but there IS a truth table for AND conditionals. Martin __ Disclaimer and confident

Enumerate MySQL Servers?

2009-03-02 Thread Menachem Bazian
I hope this is the right forum because what I asking for is not strictly MySQL itself but rather related to MySQL but here goes I need to be able to enumerate the list of any MySQL servers that are available to a computer. I can do this with SQL Server... I was wondering if anyone had a wa

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
Thank you all I solved the problem --- On Mon, 3/2/09, Darryle Steplight wrote: From: Darryle Steplight Subject: Re: Error: Duplicate entry '0' for key 'PRIMARY' To: samc...@yahoo.com Cc: mysql@lists.mysql.com, g...@primeexalia.com Date: Monday, March 2, 2009, 2:32 PM Are you trying to do an

Re: && vs AND

2009-03-02 Thread John Daisley
Never seen && used with MySQL, does it really work??? As for other RDBMS, I reckon its likely to cause problems in Oracle as && is used for session substitution variables in SQL*Plus. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administr

Re: Enumerate MySQL Servers?

2009-03-02 Thread Claudio Nanni
If you are designing a microsoft windows software to connect to MySQL servers the easiest way to create connections is to use the ODBC Drivers provided by mysql ( http://dev.mysql.com/downloads/connector/odbc/5.1.html). Once installed the drivers you will have to create the (System) Data Source Nam

Re: && vs AND

2009-03-02 Thread Jim Lyons
Yes - it works in MySQL, as does ||. See: http://dev.mysql.com/doc/refman/5.1/en/logical-operators.html#operator_and On Mon, Mar 2, 2009 at 5:02 PM, John Daisley < john.dais...@mypostoffice.co.uk> wrote: > Never seen && used with MySQL, does it really work??? > > As for other RDBMS, I reckon

drop down menu to a table

2009-03-02 Thread sam rumaizan
How do I insert data from a drop down menu  (select box) to a table

RE: Enumerate MySQL Servers?

2009-03-02 Thread Martin Gainty
will you be supporting clusters? if not you can scan for listeners on 3306 HTH Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confiden

Re: Enumerate MySQL Servers?

2009-03-02 Thread michael
Someone said look at you ODBC DNS list, and I think you are asking for a method to programmatically find MySql servers, without looking at a ODBC list on your screen. If I were you, I would start/temporarily with assuming the MySql are listening on port 3306, and write the appropriate socket code

Re: Enumerate MySQL Servers?

2009-03-02 Thread michael
Correction: If you get "Connection failed" no one is listening! "Connection Refused" means someone is listening, you just don't know who. > Someone said look at you ODBC DNS list, and I think you are asking for a > method to programmatically find MySql servers, without looking at a ODBC > list