Wilbert: > i have this php script which queries a table. The results are > stored in a > temprrary table > "CREATE temporary TABLE t1 SELECT .....statements..."; > when I query this table in the same script i can see that the > results wore > indeed stored in t1. > however when i call this table from a different script I get > the error thet > t1 doesn't exists....
I beliebe this is because temporary tables are only accessible from (and in) the session in which they are created, once the session closes the tables dissapear. Do a search for "temporary" in the MySQL manual (http://www.mysql.com) for more info on temporary tables. -H --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
