Re: free ERD tool for MySql

[denys]

Dana Henderson a écrit :
Andrew, 


You can download a FREE version of MY dbPAL for MySQL at www.it-map.com
to help you out with this.  My product is free, it does database and data
migrations, schema editing, data modeling,  change management, database
documentation and has ETL tools in there as well.
hi dana
I tried downloading MYdbPAL and when I clicked on Submit I receive the 
following error :
ProcessForm Exception = Access violation at address 014A81B0 in module 
'WebFormsP.dll'.
Read of address 0004
I'm french and I don't use the State field of the form (ie just 
putting a '*' in it).
Do you think this could be the problem ?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: free ERD tool for MySql

[denys]

Attila Horvath a crit :
No I get the same problem and I'm from U.S.! :-(
Attila
It was just a temporary problem, I tried it again just now and it worked.
Denys
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: detect rows that has zero values

[denys]

Louie Miranda a écrit :
Im trying not to list the rows that has zero values.
this is my current select statement:
select id,country_city from rates_ocean order by country_city
The fields that i have to detect are:
fieldvalue1
fieldvalue2
fieldvalue3
how can i do this on mysql, ex:
select country from rates (if fieldvalue1,fieldvalue2,fieldvalue3 = 0
(do not display)) order by country;
 

SELECT  country
FROM Rates
WHERE fieldvalue1  0 AND fieldvalue2  0 AND fieldvalue3  0
ORDER BY country
is it what you want ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: detect rows that has zero values

[Bulant Denys]

 --- Michael Stassen [EMAIL PROTECTED] a
écrit : 
 denys wrote:
 
   SELECT  country
   FROM Rates
   WHERE fieldvalue1  0 AND fieldvalue2  0 AND
 fieldvalue3  0
   ORDER BY country
   is it what you want ?
  
 
 Gleb Paharenko wrote:
 
  Hello
  
  You may use query like this:
   select country from rates where (fieldvalue1 !=0)
 and (fieldvalue2 !=0) 
   and (fieldvalue3 !=0) order by country;
  
  See:
   

http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
 
 And since 0 is false and every other number is true,
 this could be 
 simplified to
 
SELECT country
FROM Rates
WHERE fieldvalue1 AND fieldvalue2 AND fieldvalue3
ORDER BY country;
 
 Michael
 
 

I will go to bed less fool this evening... Is it just
a clearest way to write it, or is there some
performance issues too ?






Vous manquez d’espace pour stocker vos mails ? 
Yahoo! Mail vous offre GRATUITEMENT 100 Mo !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour 
dialoguer instantanément avec vos amis. A télécharger gratuitement sur 
http://fr.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]