GUI Client for Redhat 7.2

[Mark Selby]

Help!

I'm at a loss as to a GUI that I can run and just edit the damn data in
a grid format (there's millions of tools to modify the database
structures.)

I'm on RedHat 7.2 so KMysql isn't supported.

If anyone has found a good one, I'd love to know (similar to pgaccess is
absolutely fine - open source though please.)

Thanks,

Mark.



-
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

Join query

[Mark Selby]

Hi All,

I have a products table with usual id and price fields etc.
The site uses prepay, in that you have a balance (eg £500)
and I'm trying to make an add to basket query where, in one
shot, I want something like
SELECT sum(value)-(SELECT price FROM p_products WHERE seq_id = 88) as
balance FROM vouchers WHERE balance > 0;

Vouchers table holds their voucher allocations (normal sum of "value"
column in vouchers gives me their balance) and I obviously only want 
to add the product to the cart when it still leaves a balance > 0;

HELP !!!

Thanks,

Mark.


-- 

-
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

Re: Searching text fields

[Mark Selby]

> database,sql,query

> Hi All,
> 
> Is there a nice way to take a search string eg
> "America spying China" and search a text or
> blob field for occurances of all of the words
> in the text in any order (ie not just a literal
> string match, but the equivalent of
> AND X LIKE "%America%" AND X LIKE "%China%" AND
> X LIKE "%spying%")
> 
> I'm not on the list so please reply to this address.
> 
> Thanks in advance,
> 
> Mark.
> 
> 
> -- 
> Mail Headers
> 
> 
> 
-- 


-
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

C API

[Mark Selby]

Hi all,

When having performed a query with a LIMIT, is there any way to get
the total records that would have been retrieved without the LIMIT
being used (other than building and executing a separate COUNT (*)
query) ?

Please CC  to this email address as I'm not currently
subscribed to the list. Thanks,

Mark.



-
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