Tables on the Fly with MySQL
Posted: Thu Jul 24, 2003 5:51 pm
Hello All,
Lets say I have 3 tables and I want to query them using INNER JOIN. What I would like todo is first query table1 and table2 and store the resultset in a "table that would be created on the fly", lets name it table10, then I would query table10 and table3 and use the results to display info on my website. Is something like this possible. Does MySQL support creating tables on the fly? and if yes? then how do I go about doing something like this.
Regards,
Pistolfire99
Lets say I have 3 tables and I want to query them using INNER JOIN. What I would like todo is first query table1 and table2 and store the resultset in a "table that would be created on the fly", lets name it table10, then I would query table10 and table3 and use the results to display info on my website. Is something like this possible. Does MySQL support creating tables on the fly? and if yes? then how do I go about doing something like this.
Regards,
Pistolfire99