http://wiki.lordwektabyte.cat/index.php?action=history&feed=atom&title=ASIX%2FM02%2FUF2%2FA08%2FE3 2026-05-04T17:33:08Z Historial de revisió per a aquesta pàgina del wiki MediaWiki 1.34.0 http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A08/E3&diff=4925&oldid=prev 2020-04-15T11:19:43Z

<p>Guillem ha mogut <a href="/index.php?title=M02/UF2/A08/E3&amp;action=edit&amp;redlink=1" class="new" title="M02/UF2/A08/E3 (encara no existeix)">M02/UF2/A08/E3</a> a <a href="/wiki/ASIX/M02/UF2/A08/E3" title="ASIX/M02/UF2/A08/E3">ASIX/M02/UF2/A08/E3</a> sense deixar una redirecció: Crear subnivell ASIX</p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr class="diff-title" lang="ca"> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Versió més antiga</td> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revisió del 11:19, 15 abr 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="ca"><div class="mw-diff-empty">(Cap diferència)</div> </td></tr></table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A08/E3&diff=791&oldid=prev 2018-05-07T17:40:30Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ca"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Versió més antiga</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revisió del 17:40, 7 maig 2018</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Línia 1:</td> <td colspan="2" class="diff-lineno">Línia 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:M02]]</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Titol|Pt83-Pràctica de creació i eliminació d'indexs}}</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Titol|Pt83-Pràctica de creació i eliminació d'indexs}}</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Capcalera|Guillem Solà i Boeck|05}}</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Capcalera|Guillem Solà i Boeck|05}}</div></td></tr> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A08/E3&diff=95&oldid=prev 2018-01-14T21:23:39Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ca"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Versió més antiga</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revisió del 21:23, 14 gen 2018</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Línia 1:</td> <td colspan="2" class="diff-lineno">Línia 1:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Titol|Pt83-Pràctica de creació i eliminació d'indexs}}</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{Titol|Pt83-Pràctica de creació i eliminació d'indexs}}</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">=Pt83. </del>Guillem Solà <del class="diffchange diffchange-inline">PC05=</del></div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">{{Capcalera|</ins>Guillem Solà <ins class="diffchange diffchange-inline">i Boeck|05}}</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Sobre la base de dades Documents, fer les preguntes:==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Sobre la base de dades Documents, fer les preguntes:==</div></td></tr> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A08/E3&diff=75&oldid=prev 2018-01-14T21:13:03Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="ca"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Versió més antiga</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revisió del 21:13, 14 gen 2018</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Línia 1:</td> <td colspan="2" class="diff-lineno">Línia 1:</td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">{{Titol|Pt83-Pràctica de creació i eliminació d'indexs}}</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Pt83. Guillem Solà PC05=</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Pt83. Guillem Solà PC05=</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A08/E3&diff=45&oldid=prev 2018-01-14T20:43:36Z

<p>Es crea la pàgina amb «=Pt83. Guillem Solà PC05= ==Sobre la base de dades Documents, fer les preguntes:== ===Crear Index=== Crear un index diferent de la PK, per cada taula. Creo Index a...».</p> <p><b>Pàgina nova</b></p><div>=Pt83. Guillem Solà PC05=<br /> <br /> ==Sobre la base de dades Documents, fer les preguntes:==<br /> <br /> ===Crear Index===<br /> Crear un index diferent de la PK, per cada taula.<br /> <br /> Creo Index a la taula documents pel camp ''Tipus''<br /> &lt;source lang=&quot;mysqle&quot;&gt;<br /> MariaDB [documents]&gt; CREATE INDEX IF NOT EXISTS IX_Tipus ON Document (Tipus);<br /> Query OK, 0 rows affected (0.23 sec)<br /> Records: 0 Duplicates: 0 Warnings: 0<br /> &lt;/source&gt;<br /> <br /> Creo Index a la taula Tema per al camp ''Subtema''<br /> &lt;source lang=&quot;mysqle&quot;&gt;<br /> MariaDB [documents]&gt; CREATE INDEX IF NOT EXISTS IX_SubTema ON Tema (SubTema);<br /> Query OK, 0 rows affected (0.25 sec)<br /> Records: 0 Duplicates: 0 Warnings: 0<br /> &lt;/source&gt;<br /> <br /> Per a la taula TemaDoc no creo cap Index perquè els 2 camps que formen la taula formen la PK i, per tant, ja són índex.<br /> <br /> ===Modificar Index===<br /> Modificar els indexs dels camps ''nom'' per a que siguin DESC<br /> Com que no existeix una instrucció &quot;DROP INDEX&quot; hem d'eliminar-lo i tornar a crear de la següent manera:<br /> <br /> Per a la taula Document:<br /> &lt;source lang=&quot;mysqle&quot;&gt;<br /> MariaDB [documents]&gt; ALTER TABLE Document DROP INDEX Nom;<br /> Query OK, 0 rows affected (0.10 sec)<br /> Records: 0 Duplicates: 0 Warnings: 0<br /> <br /> MariaDB [documents]&gt; CREATE INDEX IF NOT EXISTS Nom ON Document (Nom DESC);<br /> Query OK, 0 rows affected (0.44 sec)<br /> Records: 0 Duplicates: 0 Warnings: 0<br /> &lt;/source&gt;<br /> <br /> Per a la taula Tema:<br /> &lt;source lang=&quot;mysqle&quot;&gt;<br /> MariaDB [documents]&gt; ALTER TABLE Tema DROP INDEX Descripcio;<br /> Query OK, 0 rows affected (0.12 sec)<br /> Records: 0 Duplicates: 0 Warnings: 0<br /> <br /> MariaDB [documents]&gt; CREATE INDEX IF NOT EXISTS Descripcio ON Tema (Descripcio DESC);<br /> Query OK, 0 rows affected (0.16 sec)<br /> Records: 0 Duplicates: 0 Warnings: 0<br /> &lt;/source&gt;<br /> <br /> Finalment, puc comprovar amb &quot;SHOW INDEX FROM &lt;taula&gt;&quot; els index que hi ha a les taules corresponents:<br /> &lt;source lang=&quot;mysqle&quot;&gt;<br /> MariaDB [documents]&gt; show index from Document;<br /> +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+<br /> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |<br /> +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+<br /> | Document | 0 | PRIMARY | 1 | idDoc | A | 0 | NULL | NULL | | BTREE | | |<br /> | Document | 1 | IX_Tipus | 1 | Tipus | A | 0 | NULL | NULL | YES | BTREE | | |<br /> | Document | 1 | Nom | 1 | Nom | A | 0 | NULL | NULL | YES | BTREE | | |<br /> +----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+<br /> 3 rows in set (0.00 sec)<br /> &lt;/source&gt;<br /> <br /> &lt;source lang=&quot;mysqle&quot;&gt;<br /> MariaDB [documents]&gt; show index from Tema;<br /> +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+<br /> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |<br /> +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+<br /> | Tema | 0 | PRIMARY | 1 | idTema | A | 0 | NULL | NULL | | BTREE | | |<br /> | Tema | 1 | IX_SubTema | 1 | SubTema | A | 0 | NULL | NULL | YES | BTREE | | |<br /> | Tema | 1 | Descripcio | 1 | Descripcio | A | 0 | NULL | NULL | YES | BTREE | | |<br /> +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+<br /> 3 rows in set (0.00 sec)<br /> &lt;/source&gt;</div>

Guillem