Re: [PHP-DB] MySQL Query Question

2003-01-23 Thread Frank Peavy 
Jeremy,
This question probably should be posted to the MySql mailing list but here 
goes.
Take a look at this link:

http://www.mysql.com/doc/en/Where_optimisations.html

Your example was not very explicit so I am not sure, but I believe you are 
in need of a
WHERE clause. For example;

Select a, b, c where a >7 and c <> 0

This should get you going in the right direction.


At 03:29 PM 1/23/03 -0600, Jeremy wrote:
Hello,
I need some help from you MySQL gurus out there. This is pure SQL by the
way..no front-end.


Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have something like this

 if (columnA>'7', (columnB/columnC)  + 52, columnB/ColumnC) as "Number"

however i need to test if columnc is 0 also cause if i need divide by zero i
get a null value

I cant figure out how to do this any help would be greatly appreciated


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to copy databases?

2003-01-10 Thread Frank Peavy 
If I have a database "x" with populated tables and I would like to copy it 
to another empty database for Testing purposes, how is that done through 
phpMyAdmin?


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php