Hi MySQL Fans, hi MySQL AB ;-);

Is this structure

TRUNCATE [TEMPORARY] TABLE orginal_table_copy SELECT * FROM original_table;

planned to be supported  or perhaps even working already  and I missed 
something ?

I was thinking f.e it would be nice to update a temporary table with new data. 
Of course it would need the LOW PRIORITY option to make this when no client 
requests are done.

Until which size would it be a good idea to create temporary tables ?

Which thumb rules need to be taken care of ?

Any reply much appreciated.

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to