empty set

2011-04-26 Thread Rocio Gomez Escribano
Hi! I'm not sure it would be possible what I want to. I have a huge query, most of them are independent, and they could have not answer. What I want is when this happen, I want to change the empty set by void or 0 or something like that, here it is an example: mysql select * from

Error in accept: Too many open files

2011-04-26 Thread Brent Clark
Hiya I recently imported data on a new server (5.1). But before the importing I added the feature 'innodb_file_per_table'. I now want to enable Master - Master replication, but the problem is, im seeing the following

Re: Error in accept: Too many open files

2011-04-26 Thread Johan De Meersman
300 is pretty low - MySQL counts every instance of a table in any query as an open file. A query that uses the same table twice (with an alias, for example) thus counts for two open files. This may also be outside of MySQL, the ulimit for the user running the daemon may have open files

RE: WHERE does not work on calculated view field - Found word(s) list error in the Text body

2011-04-26 Thread Hal�sz S�ndor
2011/04/25 18:45 +, Larry McGhaw CREATE VIEW `myview2` AS SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName` FROM `mytable` a LEFT JOIN `types` b ON a.`Type` = b.`ID`; Well, for this construct IF(b.`Name` IS NULL, '', b.`Name`) there is a special function

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

2011-04-26 Thread Hal�sz S�ndor
2011/04/25 17:42 +0300, Andre Polykanine Here is the first one. We have two queries: SELECT `blogs`.* FROM `Blogs` LEFT JOIN `Users` ON `Blogs`.`UserId`=`Users`.`Id`; and the following one: SELECT `Blogs`.* FROM `Blogs`, `Users` WHERE

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

2011-04-26 Thread Suresh Kuna
I would go with join rather than where condition. 2011/4/26 Halász Sándor h...@tbbs.net 2011/04/25 17:42 +0300, Andre Polykanine Here is the first one. We have two queries: SELECT `blogs`.* FROM `Blogs` LEFT JOIN `Users` ON `Blogs`.`UserId`=`Users`.`Id`; and the following

problem starting server

2011-04-26 Thread Gergely Buday
Hi there, I installed a mysql server on my Mac using homebrew. $ mysql --version mysql  Ver 14.12 Distrib 5.0.91, for apple-darwin10.0 (i386) using EditLine wrapper When trying to start it I get $ mysql.server start Starting MySQL .. ERROR! The server quit without updating PID file

Re: empty set

2011-04-26 Thread Jo�o C�ndido de Souza Neto
As far as I know, it isn´t possible. The right way is to check how many rows your select has returned. -- João Cândido de Souza Neto Rocio Gomez Escribano r.go...@ingenia-soluciones.com escreveu na mensagem news:000601cc03e2$fd3c9540$f7b5bfc0$@go...@ingenia-soluciones.com... Hi! I'm not

PHP Generator for MySQL 11.4 released

2011-04-26 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 11.4, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ PHP

Re: problem starting server

2011-04-26 Thread Reindl Harald
Am 26.04.2011 14:56, schrieb Gergely Buday: Hi there, I installed a mysql server on my Mac using homebrew. $ mysql --version mysql Ver 14.12 Distrib 5.0.91, for apple-darwin10.0 (i386) using EditLine wrapper When trying to start it I get $ mysql.server start Starting MySQL ..

RE: empty set

2011-04-26 Thread Rocio Gomez Escribano
Thank you so much!! It works!! mysql SELECT COUNT(*) usuarios,codigo FROM usuarios WHERE codigo = 45; +--++ | usuarios | codigo | +--++ |0 | NULL | +--++ 1 row in set (0.00 sec) -Mensaje original- De: João Cândido de

RE: Error in accept: Too many open files

2011-04-26 Thread Jerry Schwartz
You are seeing *NIX error messages. You need to increase the operating system settings that control the number of files that a process can open. I'm very rusty, and never really used Linux, so I can't tell you the exact parameters. There are probably two: total number of open files, and files

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

2011-04-26 Thread Andre Polykanine
Hello Halбsz, Aha. So, I should write SELECT `Blogs`.* INNER JOIN `Users` ON `Users`.`Id`=`Blogs`.`UserId` instead of my original WHERE clause? Thanks! -- With best regards from Ukraine, Andre Skype: Francophile My blog: http://oire.org/menelion (mostly in Russian) Twitter:

RE: problem starting server

2011-04-26 Thread David Brian Chait
Go to the cmd line and type ps -ef , do you see mysqld listed? If so then it is already running. -Original Message- From: Gergely Buday [mailto:gbu...@gmail.com] Sent: Tuesday, April 26, 2011 5:56 AM To: mysql@lists.mysql.com Subject: problem starting server Hi there, I installed a

Re: WHERE does not work on calculated view field - Found word(s) list error in the Text body

2011-04-26 Thread Daniel Kraft
On 04/26/11 05:32, Halász Sándor wrote: 2011/04/25 18:45 +, Larry McGhaw CREATE VIEW `myview2` AS SELECT a.*, IF(b.`Name` IS NULL, '', b.`Name`) AS `TypeName` FROM `mytable` a LEFT JOIN `types` b ON a.`Type` = b.`ID`; Well, for this construct IF(b.`Name` IS NULL,

Re: LEFT JOIN and WHERE: identical or not and what is better?, etc.

2011-04-26 Thread Hal�sz S�ndor
2011/04/26 17:55 +0300, Andre Polykanine Aha. So, I should write SELECT `Blogs`.* INNER JOIN `Users` ON `Users`.`Id`=`Blogs`.`UserId` instead of my original WHERE clause? Thanks! I think so. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: PHP Generator for MySQL 11.4 released

2011-04-26 Thread Sharl.Jimh.Tsin
very useful tool,is it free? Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/26 SQL Maestro Team sql.maes...@gmail.com: Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 11.4, a powerful GUI frontend that allows you to generate