From 4a83bb1a6d5bee0892c294467618bd66b88535a7 Mon Sep 17 00:00:00 2001 From: David Luevano Alvarado Date: Sat, 5 Jun 2021 22:41:32 -0600 Subject: prettify css add support for wrap images and img/art grids --- blog/dst/a/asi_nomas_esta_quedando.html | 2 +- blog/dst/a/el_blog_ya_tiene_timestamps.html | 2 +- blog/dst/a/first_blog_post.html | 2 +- blog/dst/a/git_server_with_cgit.html | 2 +- blog/dst/a/linux_video_notes.html | 2 +- blog/dst/a/mail_server_with_postfix.html | 2 +- blog/dst/a/new_blogging_system.html | 2 +- blog/dst/a/shell_scripting_video_notes.html | 2 +- blog/dst/a/sql_video_notes.html | 6 ++++-- blog/dst/a/website_with_nginx.html | 2 +- blog/dst/index.html | 4 ++-- blog/dst/rss.xml | 6 ++++-- blog/dst/tag/@english.html | 4 ++-- blog/dst/tag/@notes.html | 4 ++-- blog/dst/tag/@server.html | 4 ++-- blog/dst/tag/@short.html | 4 ++-- blog/dst/tag/@spanish.html | 4 ++-- blog/dst/tag/@tools.html | 4 ++-- blog/dst/tag/@tutorial.html | 4 ++-- blog/dst/tag/@update.html | 4 ++-- blog/plt/base.html | 2 +- blog/plt/page_list.html | 2 +- blog/src/.files | 2 +- blog/src/a/sql_video_notes.md | 2 ++ 24 files changed, 40 insertions(+), 34 deletions(-) (limited to 'blog') diff --git a/blog/dst/a/asi_nomas_esta_quedando.html b/blog/dst/a/asi_nomas_esta_quedando.html index d8cdfc0..e66162c 100644 --- a/blog/dst/a/asi_nomas_esta_quedando.html +++ b/blog/dst/a/asi_nomas_esta_quedando.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/el_blog_ya_tiene_timestamps.html b/blog/dst/a/el_blog_ya_tiene_timestamps.html index 9136a86..acb94fa 100644 --- a/blog/dst/a/el_blog_ya_tiene_timestamps.html +++ b/blog/dst/a/el_blog_ya_tiene_timestamps.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/first_blog_post.html b/blog/dst/a/first_blog_post.html index 0acb615..388d703 100644 --- a/blog/dst/a/first_blog_post.html +++ b/blog/dst/a/first_blog_post.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/git_server_with_cgit.html b/blog/dst/a/git_server_with_cgit.html index 17fe0e4..65dbb4f 100644 --- a/blog/dst/a/git_server_with_cgit.html +++ b/blog/dst/a/git_server_with_cgit.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/linux_video_notes.html b/blog/dst/a/linux_video_notes.html index 8a7ee0e..fce901a 100644 --- a/blog/dst/a/linux_video_notes.html +++ b/blog/dst/a/linux_video_notes.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/mail_server_with_postfix.html b/blog/dst/a/mail_server_with_postfix.html index 952b84b..e07e1b8 100644 --- a/blog/dst/a/mail_server_with_postfix.html +++ b/blog/dst/a/mail_server_with_postfix.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/new_blogging_system.html b/blog/dst/a/new_blogging_system.html index 216ed0c..8e517dd 100644 --- a/blog/dst/a/new_blogging_system.html +++ b/blog/dst/a/new_blogging_system.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/shell_scripting_video_notes.html b/blog/dst/a/shell_scripting_video_notes.html index d048c1d..7d7fdd2 100644 --- a/blog/dst/a/shell_scripting_video_notes.html +++ b/blog/dst/a/shell_scripting_video_notes.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/a/sql_video_notes.html b/blog/dst/a/sql_video_notes.html index 867c265..9205eb6 100644 --- a/blog/dst/a/sql_video_notes.html +++ b/blog/dst/a/sql_video_notes.html @@ -22,7 +22,7 @@ - + @@ -190,10 +190,12 @@
  • RIGHT (OUTER) JOIN: returns all records from the right table, and the matched records from the left table.
  • FULL (OUTER) JOIN: returns all records when there is a match in either left or right table.
    • +

    INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN

    +

    Nested queries

    A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a SELECT query somewhere inside another one, for example SELECT ... IN (SELECT ...), where the nesting is occurring inside the parenthesis after the IN statement.

    A nesting isn’t constrained to the IN statement, it can appear anywhere, for example in a WHERE statement: SELECT ... WHERE something = (SELECT ...).

    @@ -222,7 +224,7 @@

    By David Luévano

    Created: Tue, Mar 02, 2021 @ 14:35 UTC

    -

    Modified: Sun, Jun 06, 2021 @ 00:22 UTC

    +

    Modified: Sun, Jun 06, 2021 @ 03:41 UTC

    Tags: english, notes

    diff --git a/blog/dst/a/website_with_nginx.html b/blog/dst/a/website_with_nginx.html index 7834b31..5cb1875 100644 --- a/blog/dst/a/website_with_nginx.html +++ b/blog/dst/a/website_with_nginx.html @@ -22,7 +22,7 @@ - + diff --git a/blog/dst/index.html b/blog/dst/index.html index 2a9b624..2d30138 100644 --- a/blog/dst/index.html +++ b/blog/dst/index.html @@ -22,7 +22,7 @@ - + @@ -96,7 +96,7 @@

    Articles

    -
      +

        June 2021

      • Jun 04 - Así nomás está quedando el página

        • May 2021

        diff --git a/blog/dst/rss.xml b/blog/dst/rss.xml index eea52d2..4a949b8 100644 --- a/blog/dst/rss.xml +++ b/blog/dst/rss.xml @@ -13,8 +13,8 @@ Copyright 2021 David Luévano Alvarado david@luevano.xyz (David Luévano Alvarado) david@luevano.xyz (David Luévano Alvarado) - Sun, 06 Jun 2021 00:30:52 GMT - Sun, 06 Jun 2021 00:30:52 GMT + Sun, 06 Jun 2021 04:16:37 GMT + Sun, 06 Jun 2021 04:16:37 GMT pyssg v0.5.5 https://validator.w3.org/feed/docs/rss2.html 30 @@ -1096,10 +1096,12 @@ function_name () {
      • RIGHT (OUTER) JOIN: returns all records from the right table, and the matched records from the left table.
      • FULL (OUTER) JOIN: returns all records when there is a match in either left or right table.
      +

      INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN

      +

      Nested queries

      A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a SELECT query somewhere inside another one, for example SELECT ... IN (SELECT ...), where the nesting is occurring inside the parenthesis after the IN statement.

      A nesting isn’t constrained to the IN statement, it can appear anywhere, for example in a WHERE statement: SELECT ... WHERE something = (SELECT ...).

      diff --git a/blog/dst/tag/@english.html b/blog/dst/tag/@english.html index e42a8fd..62d8ea3 100644 --- a/blog/dst/tag/@english.html +++ b/blog/dst/tag/@english.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

      Posts filtered by english

      Articles

      -
        +

          May 2021

        • May 28 - I'm using a new blogging system

          • March 2021

          diff --git a/blog/dst/tag/@notes.html b/blog/dst/tag/@notes.html index a42d265..d4a1216 100644 --- a/blog/dst/tag/@notes.html +++ b/blog/dst/tag/@notes.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

          Posts filtered by notes

          Articles

          -
            +

              March 2021

            • Mar 14 - Shell scripting tutorial video notes
            • Mar 14 - Linux tutorial video notes
              • diff --git a/blog/dst/tag/@server.html b/blog/dst/tag/@server.html index 59b857b..8f4ad53 100644 --- a/blog/dst/tag/@server.html +++ b/blog/dst/tag/@server.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

              Posts filtered by server

              Articles

              -
                +

                  March 2021

                • Mar 21 - Create a git server and setup cgit web app (on Nginx)
                • Mar 21 - Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM
                  • diff --git a/blog/dst/tag/@short.html b/blog/dst/tag/@short.html index 96721d0..0157d7f 100644 --- a/blog/dst/tag/@short.html +++ b/blog/dst/tag/@short.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

                  Posts filtered by short

                  Articles

                  -
                    +

                      June 2021

                    • Jun 04 - Así nomás está quedando el página

                      • May 2021

                      diff --git a/blog/dst/tag/@spanish.html b/blog/dst/tag/@spanish.html index b2f72c4..9788ed0 100644 --- a/blog/dst/tag/@spanish.html +++ b/blog/dst/tag/@spanish.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

                      Posts filtered by spanish

                      Articles

                      -
                        +

                          June 2021

                        • Jun 04 - Así nomás está quedando el página

                          • March 2021

                          diff --git a/blog/dst/tag/@tools.html b/blog/dst/tag/@tools.html index e137805..fcc6d4b 100644 --- a/blog/dst/tag/@tools.html +++ b/blog/dst/tag/@tools.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

                          Posts filtered by tools

                          Articles

                          -
                            +

                              May 2021

                            • May 28 - I'm using a new blogging system

                              • March 2021

                              diff --git a/blog/dst/tag/@tutorial.html b/blog/dst/tag/@tutorial.html index 44a471c..308f334 100644 --- a/blog/dst/tag/@tutorial.html +++ b/blog/dst/tag/@tutorial.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

                              Posts filtered by tutorial

                              Articles

                              -
                                +

                                  March 2021

                                • Mar 21 - Create a git server and setup cgit web app (on Nginx)
                                • Mar 21 - Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM
                                  • diff --git a/blog/dst/tag/@update.html b/blog/dst/tag/@update.html index b3e14cf..f05dee2 100644 --- a/blog/dst/tag/@update.html +++ b/blog/dst/tag/@update.html @@ -22,7 +22,7 @@ - + @@ -82,7 +82,7 @@

                                  Posts filtered by update

                                  Articles

                                  -
                                    +

                                      June 2021

                                    • Jun 04 - Así nomás está quedando el página

                                      • May 2021

                                      diff --git a/blog/plt/base.html b/blog/plt/base.html index 19377d3..42564d0 100644 --- a/blog/plt/base.html +++ b/blog/plt/base.html @@ -22,7 +22,7 @@ - + {%block head_og%}{%endblock head_og%} diff --git a/blog/plt/page_list.html b/blog/plt/page_list.html index 16dc4d5..bd1f678 100644 --- a/blog/plt/page_list.html +++ b/blog/plt/page_list.html @@ -1,6 +1,6 @@ {%macro print(pages)%}

                                      Articles

                                      -
                                        +
                                          {%for p in pages%} {%if loop.previtem%} {%if loop.previtem.cdate_list_sep !=p.cdate_list_sep%} diff --git a/blog/src/.files b/blog/src/.files index 361c663..d74933b 100644 --- a/blog/src/.files +++ b/blog/src/.files @@ -2,7 +2,7 @@ a/website_with_nginx.md 1616122695.085315 1622938985.447357 english,server,tools a/git_server_with_cgit.md 1616353229.8983006 1622793595.4845119 english,server,tools,tutorial a/el_blog_ya_tiene_timestamps.md 1615862784.9032707 1621284818.4731243 short,spanish,tools,update a/shell_scripting_video_notes.md 1615701454.6499224 1622793622.0414143 english,notes -a/sql_video_notes.md 1614695711.6048582 1622938935.8065531 english,notes +a/sql_video_notes.md 1614695711.6048582 1622950879.0081563 english,notes a/first_blog_post.md 1614431313.2090824 1621284833.6700118 english,short,tools,update a/linux_video_notes.md 1615701443.6397786 1622793573.704325 english,notes a/mail_server_with_postfix.md 1616299559.6570284 1622939041.148257 english,server,tools,tutorial diff --git a/blog/src/a/sql_video_notes.md b/blog/src/a/sql_video_notes.md index 91c5976..ff20f26 100644 --- a/blog/src/a/sql_video_notes.md +++ b/blog/src/a/sql_video_notes.md @@ -140,10 +140,12 @@ There are different types of SQL JOINs: * `RIGHT (OUTER) JOIN`: returns all records from the right table, and the matched records from the left table. * `FULL (OUTER) JOIN`: returns all records when there is a match in either left or right table. +
                                          ![INNER JOIN](images/b/notes/sql/img_innerjoin.gif) ![LEFT JOIN](images/b/notes/sql/img_leftjoin.gif) ![RIGHT JOIN](images/b/notes/sql/img_rightjoin.gif) ![FULL OUTER JOIN](images/b/notes/sql/img_fulljoin.gif) +
                                          #### Nested queries -- cgit v1.2.3-54-g00ecf