deepakfugo Posted July 16, 2013 Share Posted July 16, 2013 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 Quote Link to comment Share on other sites More sharing options...
Barand Posted July 16, 2013 Share Posted July 16, 2013 The best method is don't use dynamic tables. Use a single table with the date in the records. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.