On May 3, 2013 12:15 PM, "Yang Zhang" wrote:
> I have an `account` table with 5.3M rows, with primary key `id` of
> type `text` (and 600+ columns if that matters).
>
> I'm trying to create a `newaccount` table with the same schema but
> 600k newly imported rows, then insert all the old rows for w
i think this query can be rewritten as
SELECT claim_id,sum(invoices),sum(payments)
FROM logs
GROUP BY claim_id
HAVING sum(invoices) > 0 OR sum(payments) > 0;
having clause can be used with aggregate functions but
those functions should be the part of column
list/expression list in the SELECT
**
table it should add the bitset of the that role from
role_list table into user_list table.
but this trigger hangs at the update command.
anybody have any suggestion ?
pradeep singh
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the bes
