Re: A new GUI for mySQL

[Dennis Megarry]

Sounds great!  I'm all for GUI's for MySQL!

It would help if you put some screen shots on your site so we can see what
its interface is like before we download and install.  Speaking for myself,
my hard drive is full of stuff I've downloaded just to find out it isn't
what I was looking for.

Dennis

- Original Message -
From: Ritesh Nadhani [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, May 19, 2002 9:25 AM
Subject: A new GUI for mySQL


 greetings...
 Webyog has released mySQLyog, a win32 based Query
 analyzer. Its FREE and gives all the features that a
 mysql developer can ask for by a query analyzer.
 please visit www.webyog.com
 you can execute query of results of more than 10
 records, supports multiple query execution and you can
 export your data into XML, HTML and CSV and can also
 import form a text file.
 It also allows you to excute last query and lets you
 add your favourite query in a personal folder with one
 click of mouse. So you dont have to save it and open
 it.
 Please take a look at it and feel free to send your
 suggestions to [EMAIL PROTECTED]
 Ritesh


 __
 Do You Yahoo!?
 LAUNCH - Your Yahoo! Music Experience
 http://launch.yahoo.com

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Query question in join table with null

[Dennis Megarry]

I have been battling with a complex query that us giving me a tremendous
headache..

I have a MASTER table with 7 other tables (I can not change the database)
The master table contains values (Key's) which I then need to lookup in
another table that has 2 fields, the Key and a Description field.
Everything works fine, but when one field in the master table has a null
value, the entire query craps out.  In MSSQL, I would use a IF THEN ELSE
statement to get around this..   Is there such a feature in MySQL (running
v3.23)?

My Query is below:

Select
MASTER.N_NUMBER,
MASTER.SERIAL_NUMBER,
MASTER.YEAR_MFR,
MASTER.REGISTRANT_NAME,
MASTER.STREET1,
MASTER.STREET2,
MASTER.REGISTRANT_CITY,
MASTER.REGISTRANT_STATE,
MASTER.REGISTRANT_ZIP_CODE,
MASTER.REGISTRANT_REGION,
MASTER.COUNTY_MAIL,
MASTER.COUNTRY,
MASTER.LAST_ACTION_DATE,
MASTER.CERTIFICATE_ISSUE_DATE,
MASTER.APPROVED_OPERATION_CODES,
MASTER.TYPE_ENGINE,
MASTER.MODE_S_CODE,
MASTER.FRACT_OWNER,
ACFTREF.MANUFACTURER_NAME,
ACFTREF.MODEL_NAME,
ACFTREF.AIRCRAFT_TYPE,
ACFTREF.ENGINE_TYPE,
ACFTREF.AIRCRAFT_CATEGORY,
ACFTREF.AMATEUR_CERTIFICATION,
ACFTREF.NUMBER_ENGINES,
ACFTREF.NUMBER_SEATS,
ACFTREF.AIRCRAFT_WEIGHT,
ACFTREF.AIRCRAFT_CRUISING_SPEED,
AIRCRAFT_CODES.DESCRIPTION,
AIRWORTHINESS_CODES.DESCRIPTION,
ENGINE.ENGINE_MANUFACTURER,
ENGINE.ENGINE_MODEL_NAME,
ENGINE.ENGINE_TYPE,
ENGINE.ENGINE_HORSEPOWER_THRUST,
ENGINE.FUEL_CONSUMED,
REGISTRANT_CODES.DESCRIPTION,
MASTER_STATUS_CODES.DESCRIPTION
From
MASTER   MASTER,
ACFTREF   ACFTREF,
AIRCRAFT_CODES   AIRCRAFT_CODES,
AIRWORTHINESS_CODES   AIRWORTHINESS_CODES,
ENGINE   ENGINE,
REGISTRANT_CODES   REGISTRANT_CODES,
MASTER_STATUS_CODES   MASTER_STATUS_CODES
Where (
MASTER.AIRCRAFT_MFR_MODEL = ACFTREF.MANUFACTURER_MODEL_SERIES
AndMASTER.TYPE_AIRCRAFT = AIRCRAFT_CODES.AIRCRAFT_CODE
AndMASTER.AIRWORTHINESS_CLASSIFICATION =
AIRWORTHINESS_CODES.AIRWORTHINESS_CODE
AndMASTER.ENGINE_MFR_MODEL = ENGINE.ENGINE_CODE
AndMASTER.TYPE_REGISTRANT = REGISTRANT_CODES.REGISTRANT_CODE
AndMASTER.STATUS = MASTER_STATUS_CODES.STATUS_CODE
) AND MASTER.N_NUMBER = '3868J'

The MASTER.STATUS field is the one that could sometimes contain a NULL..

Any help would be greatly appreciated!

Dennis



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php