When I moved from type=memory to the default DB it worked fine. I am
starting to think that the quantity of rows i.e. 550K approx was too
much for my memory on my computer to handle. Does this make sense?
On 11/25/06, John Kopanas <[EMAIL PROTECTED]> wrote:
I create a memory table with the following query:
CREATE TABLE company_totals type=memory
SELECT company_id id, SUM(annual_service_charge) service_charge
FROM purchased_services ps
GROUP BY company_id;")
When I try this I get the following error:
Mysql::Error: The table 'company_totals' is full:
So I decided to see what is in the table:
SELECT * FROM company_totals;
And I get the following error:
ERROR 1146 (42S02): Table 'opportunity_development.company_totals' doesn't exist
Even when I do a: SHOW TABLE STATUS the table is not listed.
So, where is this table? Why does mySQL think it is full but does not
think it exists at the same time? Help :-)
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
