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