Hello again,
within a small some-kind-of content-mangement site, I create a temporary table by
CREATE TEMPORARY TABLE XY SELECT * FROM XY.
Changes on this temp table can now only be seen (with a 'select * from XY') ONLY, if the select statement is executed with the same link identifier as the 'CREATE' statement. If you connect to the DB with another ID, you will see the original table, not the temp-table.
That means, a web-site eg., that runs a select query over table XY always receives values of my original table XY, UNLESS it uses the link identifier mentioned above.
QUESTION:
How can I pass the link identifier from my content-mangement system to web-site, so that a select query from the web site receives values from the created temporary table and NOT the original (which has never been touched).
Hope, I could make myself understood!
thanks a lot!
Thomas
within a small some-kind-of content-mangement site, I create a temporary table by
CREATE TEMPORARY TABLE XY SELECT * FROM XY.
Changes on this temp table can now only be seen (with a 'select * from XY') ONLY, if the select statement is executed with the same link identifier as the 'CREATE' statement. If you connect to the DB with another ID, you will see the original table, not the temp-table.
That means, a web-site eg., that runs a select query over table XY always receives values of my original table XY, UNLESS it uses the link identifier mentioned above.
QUESTION:
How can I pass the link identifier from my content-mangement system to web-site, so that a select query from the web site receives values from the created temporary table and NOT the original (which has never been touched).
Hope, I could make myself understood!
thanks a lot!
Thomas