jemajoign

I'd be interested in the solution to this too. Right now, the only way I know how to do it with any decent performance is to use a cheap trick using string concatenation and de-concatenation. I would post it here, but I'd be embarrassed if someone were to post a …

Yes. You can write a script and schedule it through your OS. [url]http://dev.mysql.com/doc/refman/5.0/en/batch-mode.html[/url]

If by 'pair up' you mean that you want them to appear in the same row, I think the approach would be to join the table to itself. So if you had a table like: [code] id description linkid 1 item 1 3 2 item 2 1 3 item 3 …

Is this what you need? [code=sql] select i, substring_index(source_ip, '.', i) source_ip_new, count(*) as myCount from ( select (1) as i union select (2) union select (3) union select (4) ) as n join userbase_copy group by i, source_ip_new with rollup having i = 3 and count(*) > 0; [/code]

I was trying to create a moving average. Here's the sample data: [code=MySQL] create temporary table if not exists window (id int); delete from window; insert into window(id) select 1 union select 2 union select 3 union select 4 union select 15 union select 6 union select 7 union select …

Just an additional note about the pronunciation of "MySQL": From [url]http://forge.mysql.com/wiki/MySQLFAQ[/url] How do I pronounce MySQL? MySQL is pronounced "My Ess Que Ell" ("My S Q L"). But we're friendly people, so we don't get angry if people say "Mysequel". ;-)

What do you mean when you say you want to find out "how many tables actually have the same variable as the key table?"