Jump to content

Data fetching from multiple table dynamic


deepakfugo

Recommended Posts

Hi All,

 

I want to select rows from dynamic created tables i.e we have tables like web_analytics_mm_yy(ex: web_analytics_06_13, web_analytics_05_13, web_analytics_04_13 and so on)

  • web_analytics ->common name for all tables
  • mm_yy -> month_year( Will be creating each month)
HOW to construct SQL STATEMENT USING UNION ALL?

is there any thing that can be done using mysql Query only?

and i want to know what is the best method to fetch data from multiple tables which are created dynamic.

 

Thx ppl

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.