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

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 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

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: && 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

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 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: 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

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: && 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

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: 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.

&& 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
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

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 ?

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

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

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

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

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 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