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 Link to comment https://forums.phpfreaks.com/topic/280190-data-fetching-from-multiple-table-dynamic/ 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. Link to comment https://forums.phpfreaks.com/topic/280190-data-fetching-from-multiple-table-dynamic/#findComment-1440899 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.