MySQL University session on March 5: Good Coding Style
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 University sessions, point your browser to this page: http://webmeeting.dimdim.com/portal/JoinForm.action?confKey=mysqluniversity You need a browser with a working Flash plugin. You may register for a Dimdim account, but you don't have to. (Dimdim is the conferencing system we're using for MySQL University sessions. It provides integrated voice streaming, chat, whiteboard, session recording, and more.) MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session. Here's the schedule for the upcoming weeks (see http://forge.mysql.com/wiki/MySQL_University for a better format of this list): March 5, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow)Good Coding Style Konstantin Osipov March 12, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 GMT / 15:00 CET / 17:00 MDT (Moscow) MySQL and ZFS MC Brown March 19, 2009 14:00 UTC / 8am CST (Central) / 9am EST (Eastern) / 14:00 BST / 15:00 CET / 17:00 MDT (Moscow) How to Use Charsets and Collations Properly Susanne Ebrecht Cheers, Stefan -- *** Sun Microsystems GmbHStefan Hinz Sonnenallee 1Manager Documentation, Database Group 85551 Kirchheim-Heimstetten Phone: +49-30-82702940 Germany Fax: +49-30-82702941 http://www.sun.de/mysql mailto: stefan.h...@sun.com Amtsgericht Muenchen: HRB161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Ofertas em Higiêne Bucal
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 receber e-mail de nosso site. Você pode remover se não quizer mais receber e-mails. IONIC WHITE - CLAREADOR DE DENTES - 21 MINUTOS - LUZ ATIVADO POR 129,00 Waterpik Fio Dental c/ Pontas Clareados por 95,00 Waterpik Ultra WP-100 Por 299,00 reaisESCOVA SENTAL SENSONIC POR 359,00 REAIS WATERPIK WP-450 PORTÁTIL POR 280,00
MySQL Binary Log Summary Tool
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 sense in improving it. Thanks in advance Claudio
MySQL Binary Log Summary Tool - w/link!
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 sense in improving it. Thanks in advance Claudio http://forge.mysql.com/tools/tool.php?id=185
10 times faster MySQL
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 transactions pr second!! More info can be found on http://www.dolphinics.com/solutions/mysql.html and http://www.bigdbahead.com/?p=119 We are setting up a MySQL test environment that will be available for remote login. We would like to work with some of you to run and report real life application results. Best regards Hugo = Hugo Kohmann | Dolphin Interconnect Solutions AS | E-mail: P.O. Box 150 Oppsal| hu...@dolphinics.com N-0619 Oslo, Norway| Web: Tel:+47 23 16 71 83| http://www.dolphinics.com Fax:+47 23 16 71 80| Visiting Address: Olaf Helsets vei 6 | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Marmaris Değirmenyanında görkemli ikiz villa
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 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:Normal Tablo; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:Calibri,sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} Günlük ve Çam ormanlarıyla çevrili tertemiz bir doğada yaşamaya ne dersiniz. Marmaris'in şirin beldesi Hisarönü'ne yalnızca 3 km uzaklıktaki Değirmenyanı olarak bilinen yerleşkede çok değerli villa. İki yüz bin TL'ye satılmakta olan bu şirin villa, kampanya çerçevesinde yalnızca 175.000 TL'dir. Bu fırsat bir daha ele geçmez. Detaylı bilgi ve resimler için www.hurriyetemlak.com adresinde 20557-9 no'lu ürüne bakınız ya da http://www.hurriyetemlak.com/real_estate/residence/advertise_detail.php?ad_id=1984773 linkini tıklayınız. Eritre Danışmanlıkamp;Sarnıç Emlak eritre.emlak.net 0 554 724 40 20
Error: Duplicate entry '0' for key 'PRIMARY'
Error: Duplicate entry '0' for key 'PRIMARY' how can i fix it ?
Re: Error: Duplicate entry '0' for key 'PRIMARY'
How do I modify the column to add value? Can I do it with phpmyadmin? --- On Mon, 3/2/09, Gary Smith g...@primeexalia.com wrote: From: Gary Smith g...@primeexalia.com 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. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Duplicate entry '0' for key 'PRIMARY' Error: Duplicate entry '0' for key 'PRIMARY' how can i fix it ? Sent via BlackBerry by ATT
vs AND
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/refman/5.0/en/logical-operators.html
Re: Error: Duplicate entry '0' for key 'PRIMARY'
Are you talking about Length/Values1 --- On Mon, 3/2/09, Gary Smith g...@primeexalia.com wrote: From: Gary Smith g...@primeexalia.com 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. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Duplicate entry '0' for key 'PRIMARY' Error: Duplicate entry '0' for key 'PRIMARY' how can i fix it ? Sent via BlackBerry by ATT
Re: Error: Duplicate entry '0' for key 'PRIMARY'
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 samc...@yahoo.com wrote: Are you talking about Length/Values1 --- On Mon, 3/2/09, Gary Smith g...@primeexalia.com wrote: From: Gary Smith g...@primeexalia.com 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. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Duplicate entry '0' for key 'PRIMARY' Error: Duplicate entry '0' for key 'PRIMARY' how can i fix it ? Sent via BlackBerry by ATT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: vs AND
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 confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Subject: vs AND From: dae...@daevid.com To: mysql@lists.mysql.com Date: Mon, 2 Mar 2009 13:04:32 -0800 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/refman/5.0/en/logical-operators.html _ Windows Live™ Contacts: Organize your contact list. http://windowslive.com/connect/post/marcusatmicrosoft.spaces.live.com-Blog-cns!503D1D86EBB2B53C!2285.entry?ocid=TXT_TAGLM_WL_UGC_Contacts_032009
Enumerate MySQL Servers?
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 way for doing this for MySQL Servers... The client program will be in VB or Visual FoxPro... Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Error: Duplicate entry '0' for key 'PRIMARY'
Thank you all I solved the problem --- On Mon, 3/2/09, Darryle Steplight dstepli...@gmail.com wrote: From: Darryle Steplight dstepli...@gmail.com 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 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 samc...@yahoo.com wrote: Are you talking about Length/Values1 --- On Mon, 3/2/09, Gary Smith g...@primeexalia.com wrote: From: Gary Smith g...@primeexalia.com 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. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Duplicate entry '0' for key 'PRIMARY' Error: Duplicate entry '0' for key 'PRIMARY' how can i fix it ? Sent via BlackBerry by ATT
Re: vs AND
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 Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Mon, 2009-03-02 at 13:04 -0800, Daevid Vincent wrote: 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/refman/5.0/en/logical-operators.html __ This email has been scanned by Netintelligence http://www.netintelligence.com/email
Re: Enumerate MySQL Servers?
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 Names in the ODBC control panel (Administrative Tools). You need to create at least one DSN per each MySQL database (instance) you want to connect to. Data Source Names are links that contain all the informations to estabilish the connection to a database, so including host, port, user, password, default database, and other options. Once you have created a System Data Source Name that link will be available to any application in that windows host. If you are wondering why you can see the connections to SQL Server probably ODBC DSNs have been created. There is available the .NET connector as well but I never used that, so I can't help you with that. Let me know if it helped Cheers Claudio 2009/3/2 Menachem Bazian gro...@bcconsultingservices.com 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 way for doing this for MySQL Servers... The client program will be in VB or Visual FoxPro... Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: vs AND
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 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 Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Mon, 2009-03-02 at 13:04 -0800, Daevid Vincent wrote: 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/refman/5.0/en/logical-operators.html __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
drop down menu to a table
How do I insert data from a drop down menu (select box) to a table
RE: Enumerate MySQL Servers?
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 confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Mon, 2 Mar 2009 17:00:51 -0500 From: gro...@bcconsultingservices.com To: mysql@lists.mysql.com Subject: Enumerate MySQL Servers? 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 way for doing this for MySQL Servers... The client program will be in VB or Visual FoxPro... Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Windows Live™ Groups: Create an online spot for your favorite groups to meet. http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009
Re: Enumerate MySQL Servers?
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 to connect to port 3306, starting with IP xxx.xxx.xxx.0, xxx.xxx.xxx.1, and so on until xxx.xxx.xxx.255 If you get connection refused, MySql is probably not listening on 3306, on that IP. For example: When I telnet to 127.0.0.1 port 3306 I get A5.0.45-community-nt, and some garbage. So I know there is a MySql server listening on port 3306 on my local host. Now, someone in the MySql development team should be able to tell you what the various connect strings that you may run into from various versions and platforms. Once you get this logic running smooth, then you can open it up to all ports, and have a rock solid way to find all MySql servers running on your network. That is, until a new version comes out ;-) Could be a good method to monitor your MySql servers, better than just a ping. My $0.02, Mike. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Enumerate MySQL Servers?
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 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 to connect to port 3306, starting with IP xxx.xxx.xxx.0, xxx.xxx.xxx.1, and so on until xxx.xxx.xxx.255 If you get connection refused, MySql is probably not listening on 3306, on that IP. For example: When I telnet to 127.0.0.1 port 3306 I get A5.0.45-community-nt, and some garbage. So I know there is a MySql server listening on port 3306 on my local host. Now, someone in the MySql development team should be able to tell you what the various connect strings that you may run into from various versions and platforms. Once you get this logic running smooth, then you can open it up to all ports, and have a rock solid way to find all MySql servers running on your network. That is, until a new version comes out ;-) Could be a good method to monitor your MySql servers, better than just a ping. My $0.02, Mike. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mich...@j3ksolutions.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org