How about:
select (@CNT:=count(*)) FROM table1
union
select (@CNT:[EMAIL PROTECTED](*)) from table2
union
select (@CNT:[EMAIL PROTECTED](*)) from table3;
If you want only the sum:
(select (@CNT:=count(*)) FROM table1)
union
(select (@CNT:[EMAIL PROTECTED](*)) from table2)
union
(select
From the 4.0.8 changelog:
o We now send big queries/result rows in bigger hunks,
which should give a small speed improvement.
Is this configurable ? I'd like to measure various hunk
sizes for my sql query.
/GG
-
Before
I execute the next query in Delphi 5.0 against MySQL and Delphi understand
that the column of the query is of type ftFloat
when it should be ftInteger (The field cantidad in the database is int).
SELECT SUM(cantidad) AS Ventas
FROM LALBARANCL
WHERE fecha = 2002-05-01
AND fecha