On Thu, 28 Feb 2008 11:19:40 -0500, Phil wrote: > I have 50 plus tables lets call them A_USER, B_USER, C_USER etc which I > daily refresh with updated (and sometimes new) data. > > I insert the data into a temporary table using LOAD DATA INFILE. This > works great and is very fast.
May I ask why you have fifty plus tables with, apparently, the same schema? Why not have one table with an extra column "user"? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
