http://wiki.lordwektabyte.cat/index.php?action=history&feed=atom&title=ASIX%2FM02%2FUF2%2FA03%2FE2 2026-05-06T11:22:54Z Historial de revisió per a aquesta pàgina del wiki MediaWiki 1.34.0 http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A03/E2&diff=4916&oldid=prev 2020-04-15T11:19:14Z

<p>Guillem ha mogut <a href="/index.php?title=M02/UF2/A03/E2&amp;action=edit&amp;redlink=1" class="new" title="M02/UF2/A03/E2 (encara no existeix)">M02/UF2/A03/E2</a> a <a href="/wiki/ASIX/M02/UF2/A03/E2" title="ASIX/M02/UF2/A03/E2">ASIX/M02/UF2/A03/E2</a> sense deixar una redirecció: Crear subnivell ASIX</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 11:19, 15 abr 2020</td> </tr> <!-- diff cache key wiki:diff::1.12:old-783:rev-4916 --> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A03/E2&diff=783&oldid=prev 2018-05-07T17:39:10Z

<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:39, 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|Pt32. Inserció, modificació i eliminació de dades}}</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|Pt32. Inserció, modificació i eliminació de dades}}</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> <!-- diff cache key wiki:diff::1.12:old-88:rev-783 --> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A03/E2&diff=88&oldid=prev 2018-01-14T21:21:58Z

<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:21, 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|Pt32. Inserció, modificació i eliminació de dades}}</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|Pt32. Inserció, modificació i eliminació de dades}}</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">=</del>Guillem Solà i Boeck <del class="diffchange diffchange-inline">(Ordinador PC05 (host A10BPC05))=</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à i Boeck<ins class="diffchange diffchange-inline">|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>==1. Inserir 2 ciutats a City==</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>==1. Inserir 2 ciutats a City==</div></td></tr> <!-- diff cache key wiki:diff::1.12:old-65:rev-88 --> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A03/E2&diff=65&oldid=prev 2018-01-14T21:08:13Z

<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:08, 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|Pt32. Inserció, modificació i eliminació de dades}}</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>=Guillem Solà i Boeck (Ordinador PC05 (host A10BPC05))=</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>=Guillem Solà i Boeck (Ordinador PC05 (host A10BPC05))=</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> <!-- diff cache key wiki:diff::1.12:old-35:rev-65 --> </table>

Guillem http://wiki.lordwektabyte.cat/index.php?title=ASIX/M02/UF2/A03/E2&diff=35&oldid=prev 2018-01-14T20:40:30Z

<p>Es crea la pàgina amb «=Guillem Solà i Boeck (Ordinador PC05 (host A10BPC05))= ==1. Inserir 2 ciutats a City== {{QWorld |&lt;nowiki&gt;MariaDB [world]&gt;MariaDB [world]&gt; insert into City (Name,Co...».</p> <p><b>Pàgina nova</b></p><div>=Guillem Solà i Boeck (Ordinador PC05 (host A10BPC05))=<br /> <br /> ==1. Inserir 2 ciutats a City==<br /> <br /> {{QWorld<br /> |&lt;nowiki&gt;MariaDB [world]&gt;MariaDB [world]&gt; insert into City (Name,CountryCode,District,Population) Values (&quot;Guillemlandia&quot;, &quot;AND&quot;, &quot;Boeck&quot;, 1996), (&quot;No man's Land&quot;, &quot;AND&quot;, &quot;COD&quot;, 25000);&lt;/nowiki&gt;<br /> |&lt;nowiki&gt;<br /> Query OK, 2 rows affected (0.06 sec)<br /> Records: 2 Duplicates: 0 Warnings: 0<br /> &lt;/nowiki&gt;<br /> }}<br /> <br /> ==2. Modificar els registres de EuropeCityMitja, posant a tots la mitja de la població de les ciutats==<br /> {{QWorld<br /> |&lt;nowiki&gt;MariaDB [world]&gt; update EuropeCityMitja set mitja=(select avg(population) from City);&lt;/nowiki&gt;<br /> |&lt;nowiki&gt;<br /> Query OK, 0 rows affected (0.09 sec)<br /> Rows matched: 46 Changed: 0 Warnings: 0<br /> &lt;/nowiki&gt;<br /> }}<br /> <br /> ==3. Afegeix un idioma que es parli en un 50% a Andorra i que no sigui oficial==<br /> {{QWorld<br /> |&lt;nowiki&gt;MariaDB [world]&gt; insert into CountryLanguage (CountryCode, Language, IsOfficial,Percentage) values ('AND', 'Binari', 'F','50');&lt;/nowiki&gt;<br /> |&lt;nowiki&gt;<br /> Query OK, 1 row affected (0.06 sec)<br /> <br /> &lt;/nowiki&gt;<br /> }}</div>

Guillem