<div>son tablas temporales</div>
<div> </div>
<div><pre class="programlisting">CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <em class="replaceable"><code>tbl_name</code></em>
[(<em class="replaceable"><code>create_definition</code></em>,...)]
[<em class="replaceable"><code>table_options</code></em>] [<em class="replaceable"><code>select_statement</code></em>]
</pre>
<p>Or: </p><pre class="programlisting">CREATE [TEMPORARY] TABLE [IF NOT EXISTS] <em class="replaceable"><code>tbl_name</code></em>
[(] LIKE <em class="replaceable"><code>old_tbl_name</code></em> [)];
</pre>
<p>From MySQL 3.23 on, you can use the <code class="literal">TEMPORARY</code> keyword when creating a table. A <code class="literal">TEMPORARY</code> table is visible only to the current connection, and is dropped automatically when the connection is closed. This means that two different connections can use the same temporary table name without conflicting with each other or with an existing non-
<code class="literal">TEMPORARY</code> table of the same name. (The existing table is hidden until the temporary table is dropped.) From MySQL 4.0.2 on, you must have the <code class="literal">CREATE TEMPORARY TABLES</code>
privilege to be able to create temporary tables. </p>
<p>In MySQL 3.23 or later, you can use the keywords <code class="literal">IF NOT EXISTS</code> so that an error does not occur if the table exists. Note that there is no verification that the existing table has a structure identical to that indicated by the
<code class="literal">CREATE TABLE</code> statement. Also, if you use <code class="literal">IF NOT EXISTS</code> in a <code class="literal">CREATE TABLE ... SELECT</code> statement, any records selected by the <code class="literal">
SELECT</code> part are inserted regardless of whether the table already exists. </p><br><br> </div>
<div><span class="gmail_quote">On 6/29/05, <b class="gmail_sendername">Esteban Fernández</b> <<a href="mailto:efernandez@vantageglobal.com">efernandez@vantageglobal.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Tablas temporales ?<br><br><br>-----Original Message-----<br>From: <a href="mailto:php-bounces@listas.inf.utfsm.cl">
php-bounces@listas.inf.utfsm.cl</a><br>[mailto:<a href="mailto:php-bounces@listas.inf.utfsm.cl">php-bounces@listas.inf.utfsm.cl</a>] On Behalf Of Juan Andres Ramirez<br>Sent: Miércoles, 29 de Junio de 2005 4:16<br>To: Lista php
<br>Subject: tabla virtual<br><br>Hola lista:<br> Queria saber si se puede crear una especie de tabla virtual(digamos<br>un estracto de una tabla existente) con ciertos datos, los cuales se supone<br>que se modificaran bastante, entonces una vez que se tengan todas las
<br>modificaciones, agregar estos datos a la BD??, en MYSQL??. El objetivo de<br>esto es no recorrer inecesariamente una tabla muy grande, con datos que no<br>vamos a ocupar, por cada consulta, y asi que valla mas rapido todo.
<br> En otras bases de datos se puede, pero no se si en mysql. Gracias!!<br><br>--<br>--------------------------------<br>Juan Andres Ramirez A.<br>Linux Counter: 288133<br><a href="mailto:mail2:sombra_chile@hotmail.com">
mail2:sombra_chile@hotmail.com</a><br><a href="mailto:mail3:sombra_cl@chile.com">mail3:sombra_cl@chile.com</a><br>irc.cl:#linuxhelp<br>nick: sombra<br>_<br>(o< zzz<br>//\<br>V_/_user:debian sarge<br>--------------------------------
<br><br><br></blockquote></div><br>