Re: (OT) MySQL Help

Two things that might be useful: UNION queries, which let you run several queries at once and get the results from one database handle; and MERGE tables, which let you treat several identical tables (like the ones in your example) as one big table.

--
sgifford's Web page

Comment on Re: (OT) MySQL Help

Replies are listed 'Best First'.
Re^2: (OT) MySQL Help by UnderMine (Friar) on Jun 13, 2006 at 05:51 UTC
Problem with MERGE tables is they rely on the underlying tables being identical. As I understand it only the first four columns in these tables are identical so MERGE tables will be of no use. Hope that helps UnderMine	[reply]
Re^2: (OT) MySQL Help by Tobin Cataldo (Monk) on Jun 13, 2006 at 13:08 UTC
If ID and MARK are similar across all the tables, UNION is probably the way to go. `SELECT ID, MARK FROM Table 1 UNION SELECT ID, MARK FROM Table 2 ...` [download] tobin	[reply] [d/l]