CREATE TEMPORARY TABLE + Table already exists error ошибка
Primary tabs
It's visible only to the client that created it and may be used only by that client. This means that different clients can create TEMPORARY tables that have the same name and no conflict occurs.
- A TEMPORARY table exists only for the duration of the connection in which it was created. The server drops a TEMPORARY table automatically when the client connection ends if the client has not already dropped it. This is convenient because you need not remember to remove the table yourself.
A TEMPORARY table may have the same name as a non-TEMPORARY table. The non- TEMPORARY table becomes hidden to the client that created the TEMPORARY table as long as the TEMPORARY table exists. A TEMPORARY table can be renamed only with ALTER TABLE. You cannot use RENAME TABLE.
таблица будет существовать на протяжении всей сессии подключения к СУБД- то есть до тех пор пока вы не отключитесь от базы данных (на закроете приложение с помощью которого работаете с базой данных)
_____________________________________________
Источники(читать подробнее)=
http://www.mysqlfaqs.net/mysql-faqs/Data...
____________________________________
Ключевые слова и фразы(для поиска)=
- vedro-compota's blog
- Log in to post comments
- 4850 reads