re: re: [Q] Replication temporary tables (fwd)
Andrey, Thursday, October 03, 2002, 6:08:16 PM, you wrote: Andrey, Tuesday, October 01, 2002, 11:53:41 AM, you wrote: AK Why is temporary tables replecated? AK Is it true? Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html AK Hmm... What is the reason? AK If I create a temporary table in one process, I can't use it in another. AK And after close connection table will destroy. AK What is the reason to replicate it? Andrey, you can use temporary tables in INSERT ... SELECT statement, in multi-table deletes etc. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
re: re: [Q] Replication temporary tables (fwd)
äÏÂÒÙÊ ÄÅÎØ. Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html AK Hmm... What is the reason? AK If I create a temporary table in one process, I can't use it in another. AK And after close connection table will destroy. AK What is the reason to replicate it? Andrey, you can use temporary tables in INSERT ... SELECT statement, in multi-table deletes etc. Thank you. I understand. Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - 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
re: [Q] Replication temporary tables (fwd)
Andrey, Tuesday, October 01, 2002, 11:53:41 AM, you wrote: AK Why is temporary tables replecated? AK Is it true? Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
re: [Q] Replication temporary tables (fwd)
äÏÂÒÙÊ ÄÅÎØ. sql Andrey, Tuesday, October 01, 2002, 11:53:41 AM, you wrote: AK Why is temporary tables replecated? AK Is it true? Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html Hmm... What is the reason? If I create a temporary table in one process, I can't use it in another. And after close connection table will destroy. What is the reason to replicate it? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - 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
[Q] Replication temporary tables (fwd)
sql,query Hello, All! Why is temporary tables replecated? Is it true? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - 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