All public logs

Jump to navigation Jump to search

Combined display of all available logs of SQLZOO. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

  • 03:06, 1 June 2022 Kobashi.kaz talk contribs created page Selecting NULL values./ja (Created page with "<p>Sometimes NULL values are given in tables, this might be because the data is unknown or is inappropriate. In the Parliament database a NULL value for party in the MSP table indicates that the MSP concerned is not a member of any of the parties. In the party table a NULL value is used where the party does not have an official leader - or I couldn't find one. I rather like it that the Greens and the Scottish Socialist Party don't seem to have leaders - and it suits my p...")
  • 02:57, 1 June 2022 Kobashi.kaz talk contribs created page Using Null/ja (Created page with "{{Languages| Using_Null}} <div class='ref_section'> <table class='zoo db_ref'> <caption>teacher</caption> <tr> <th>id</th> <th>dept</th> <th>name</th> <th>phone</th> <th>mobile</th> </tr> <tr> <td align='right'>101</td> <td align='right'>1</td> <td>Shrivell</td> <td align='right'>2753</td> <td>07986 555 1234</td> </tr> <tr> <td align='right'>102</td> <td align='right'>1</td> <td>Throd</td> <td align='right'>2754</td> <td>07122 555 1920</td> </tr> <tr><td align='right'>...")
  • 07:09, 26 May 2022 Kobashi.kaz talk contribs created page CASE/ja (Created page with "{{Languages| CASE}} <table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CASE WHEN b1 THEN v1 END</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr> <tr><td align='left'>ingres</td><td>Yes</td><td></td></tr> <tr><td align='left'>mysql</td><td>Yes</td><td></td></tr> <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr> <tr><td align='left'>postgres</td><td>Y...")
  • 06:54, 26 May 2022 Kobashi.kaz talk contribs created page Get to the point/ja (Created page with "{{Languages|Get_to_the_point}} <h3>Movie Database: The JOIN</h3> <p> The obvious questions about this database involve all three tables. Who appear in such-and-such a film, or which films has so-and-so appeared in. In fact we can answer some of these questions using nested <code>SELECT</code> statements that have already been covered. </p> <p>A join allows us to link two tables which have a "common" field. The id field of the actor table is referred to by the actorid fie...")
  • 09:13, 25 May 2022 Kobashi.kaz talk contribs created page Aggregates with DISTINCT/ja (Created page with " <h3>Nobel database</h3> <h2>COUNT DISTINCT</h2> <p>You can find the number of <i>different</i> values using COUNT with DISTINCT</p> <p>In 1915 four prizes were awarded in three different subjects:</p> <table class='NoBorder'><td><pre>SELECT yr, subject, winner FROM nobel WHERE yr=1915</pre> </td><td> <table border="1" class="Bordered" style=""><tr> <th>yr</th> <th>subject</th> <th>winner</th> </tr> <tr> <td align="right">1915</td> <td>Chemistry</td> <td>Rich...")
  • 06:02, 24 March 2020 Kobashi.kaz talk contribs created page Music Tutorial/ja (Created page with "<h3>音楽データベース</h3> <p>このチュートリアルで結合(join)の文法を紹介する。音楽データベースには2つのテーブル: アルバム<co...")
  • 09:17, 5 April 2018 User account Kobashi.kaz talk contribs was created