table handler error

2005-02-10 Thread David Mehringer
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20]Got error 5 from table handler Can anyone translate this for me and/or point me to a mapping of table handler error codes to their meanings? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

joins on temporary tables, and grant statement limitations

2004-12-17 Thread David Mehringer
MySQL Manual A.7.3 TEMPORARY TABLE You cannot refer to a TEMPORARY table more than once in the same query. Anything in the works to fix this pretty major limitation? Also, any chance of being able to specify wildcards in table names in GRANT statements any time soon? E.g. GRANT ALL ON

bulk loading of data

2004-09-24 Thread David Mehringer
Hello, I have a C++ application which spits out data continuously which I need to load into a database. The data rate is roughly 50,000 rows * 50 bytes/row per second. I use LOAD DATA INFILE (the quickest way I can find to load data into the db) to load these data into MyISAM tables which is