Just inheritance from an old design that has passed it's limits. I actually have a development version which does just that, but there is a lot of work to convert many php scripts and sql to include the new column. It's some way away from live though, so the problem I outlined still exists.
Phil On Tue, Mar 4, 2008 at 4:03 AM, Thufir <[EMAIL PROTECTED]> wrote: > 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] >
