OSDN Git Service

Regular updates
authorErik <erikgronwal@users.osdn.me>
Wed, 3 Nov 2021 14:55:05 +0000 (23:55 +0900)
committerErik <erikgronwal@users.osdn.me>
Wed, 3 Nov 2021 14:55:05 +0000 (23:55 +0900)
bash.md
ledger-csv.md
mysql.md

diff --git a/bash.md b/bash.md
index a7174ee..4e038e6 100644 (file)
--- a/bash.md
+++ b/bash.md
@@ -754,12 +754,13 @@ read -n 1 ans    # Just one character
 
 ### Special variables
 
-| Expression | Description                  |
-| ---------- | ---------------------------- |
-| `$?`       | Exit status of last task     |
-| `$!`       | PID of last background task  |
-| `$$`       | PID of shell                 |
-| `$0`       | Filename of the shell script |
+| Expression | Description                            |
+| ---------- | -------------------------------------- |
+| `$?`       | Exit status of last task               |
+| `$!`       | PID of last background task            |
+| `$$`       | PID of shell                           |
+| `$0`       | Filename of the shell script           |
+| `$_`       | Last argrument of the previous command |
 
 See [Special parameters](http://wiki.bash-hackers.org/syntax/shellvars#special_parameters_and_shell_variables).
 
index f7250cc..9121958 100644 (file)
@@ -13,10 +13,10 @@ $ ledger csv
 {: .-setup}
 
 ```csv
-date         , ?  , desc     , account            , currency , amt     , pending/cleared , ?
-"2013/09/02" , "" , "things" , "Assets:Cash"      , "P"      , "-2000" , "*"             , ""
-"2013/09/02" , "" , "things" , "Liabilities:Card" , "P"      , "-200"  , "*"             , ""
-"2013/09/02" , "" , "things" , "Expenses:Things"  , "P"      , "2200"  , "*"             , ""
-"2013/09/04" , "" , "stuff"  , "Assets:Cash"      , "P"      , "-20"   , "*"             , ""
-"2013/09/04" , "" , "stuff"  , "Expneses:Others"  , "P"      , "20"    , "*"             , ""
+date         , code  , desc     , account            , currency , amt     , pending/cleared , notes
+"2013/09/02" , ""    , "things" , "Assets:Cash"      , "P"      , "-2000" , "*"             , ""
+"2013/09/02" , ""    , "things" , "Liabilities:Card" , "P"      , "-200"  , "*"             , ""
+"2013/09/02" , ""    , "things" , "Expenses:Things"  , "P"      , "2200"  , "*"             , ""
+"2013/09/04" , ""    , "stuff"  , "Assets:Cash"      , "P"      , "-20"   , "*"             , ""
+"2013/09/04" , ""    , "stuff"  , "Expenses:Others"  , "P"      , "20"    , "*"             , ""
 ```
index 61b0150..445dd93 100644 (file)
--- a/mysql.md
+++ b/mysql.md
@@ -23,8 +23,8 @@ SELECT * FROM table;
 SELECT * FROM table1, table2;
 SELECT field1, field2 FROM table1, table2;
 SELECT ... FROM ... WHERE condition
-SELECT ... FROM ... WHERE condition GROUPBY field;
-SELECT ... FROM ... WHERE condition GROUPBY field HAVING condition2;
+SELECT ... FROM ... WHERE condition GROUP BY field;
+SELECT ... FROM ... WHERE condition GROUP BY field HAVING condition2;
 SELECT ... FROM ... WHERE condition ORDER BY field1, field2;
 SELECT ... FROM ... WHERE condition ORDER BY field1, field2 DESC;
 SELECT ... FROM ... WHERE condition LIMIT 10;