Re: PHP Generator for MySQL 11.4 released

very useful tool,is it free? Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/4/26 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 app

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

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

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

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.`N

RE: problem starting server

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 my

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

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: http://t

RE: Error in accept: Too many open files

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 pe

RE: empty set

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 d

Re: problem starting server

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 M

PHP Generator for MySQL 11.4 released

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 Generat

Re: empty set

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"" escreveu na mensagem news:000601cc03e2$fd3c9540$f7b5bfc0$@go...@ingenia-soluciones.com... > Hi! I'm not sure it would be possible

problem starting server

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 (/usr/local/

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

I would go with join rather than where condition. 2011/4/26 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 o

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

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 `Blogs`.`UserId`

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

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 spe

Re: Error in accept: Too many open files

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 restr

Error in accept: Too many open files

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

empty set

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 us