Re: Scaling Mysql

2009-08-24 Thread Krishna Chandra Prajapati
Yes, it's in our planning On Mon, Aug 24, 2009 at 11:10 PM, Gavin Towey wrote: > Have you looked at MySQL cluster? It was created specifically for telco > needs. > > > -Original Message- > From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] > Sent: Friday, August 21, 2009 9:2

Re: Suppressing Warnings

2009-08-24 Thread peng yao
Warning: Can't create database 'spreadsheets'; database exists This is the answer. 2009/8/24 Victor Subervi > Hi, > I have the following python code: > > cursor.execute('create database if not exists spreadsheets;') > cursor.execute('use spreadsheets;') > > but it generates this warning: > >

Re: Natural Join Issue: column names are equal but doesn't work anyways

2009-08-24 Thread muhammad subair
On Tue, Aug 25, 2009 at 6:55 AM, Deviad wrote: > Hello, > I have been training for a test on Database Design and MySQL. > The following is inside a file we have to run before starting to code > what the excercises require us to. > Call the file as you wish and run it if it helps to understand the

Re: Natural Join Issue: column names are equal but doesn't work anyways

2009-08-24 Thread Deviad
Hi again, since I'm not someone who gives up easily, I have restyled that old code (actually is from an example back of my teacher into 2002, I saw that she changed a bit her way to code this stuff), I restyled the code just to be sure it isn't some parsing issue or whatever. http://pastebin.com/f5

Natural Join Issue: column names are equal but doesn't work anyways

2009-08-24 Thread Deviad
Hello, I have been training for a test on Database Design and MySQL. The following is inside a file we have to run before starting to code what the excercises require us to. Call the file as you wish and run it if it helps to understand the reason behind my problem. --- DROP

MySQL Encryption - Third-party tools

2009-08-24 Thread Mike Scully
Hello, all. Can any of you share with me the names of any third-party tools or appliances that you are using to encrypt your MySQL databases? I am doing a search and would like to narrow down the initial search list. Thanks! Mike

RE: Scaling Mysql

2009-08-24 Thread Gavin Towey
Have you looked at MySQL cluster? It was created specifically for telco needs. -Original Message- From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com] Sent: Friday, August 21, 2009 9:23 PM To: wha...@bfs.de Cc: MySQL Subject: Re: Scaling Mysql Hi wharms, Yor are right. It's s

Re: Hi Query Optimization steps

2009-08-24 Thread mos
At 05:01 AM 8/22/2009, you wrote: Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query Huh? You need to carefully plan your table structure and use indexes sparingly on the columns you are using in the Whe

Suppressing Warnings

2009-08-24 Thread Victor Subervi
Hi, I have the following python code: cursor.execute('create database if not exists spreadsheets;') cursor.execute('use spreadsheets;') but it generates this warning: Warning (from warnings module): File "C:\Python25\mysqlConverter.py", line 140 cursor.execute('use spreadsheets;') Warn

MySQL Community Server 5.0.85 has been released

2009-08-24 Thread sunanda menon
Dear MySQL users, MySQL Community Server 5.0.85, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts. The release is now ava