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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
