The derivation of the name MySQL is not perfectly clear. Our base directory and a large number of our libraries and tools have had the prefix "my" for well over 10 years. However, Monty's daughter (some years younger) is also named My. Which of the two gave its name to MySQL is still a mystery, even for us.
The derivation of the name MySQL is not clear. Our base directory and a large number of our libraries and tools have had the prefix "my" for well over 10 years. However, co-founder Monty Widenius's daughter is also named My. Which of the two gave its name to MySQL is still a mystery, even for us.
パターン3. 言い切り：娘さんの名前だと言い切っている
MySQL is named after co-founder Monty Widenius's daughter, My.
It is not perfectly clear where the name MySQL derives from. Our base directory and a large amount of our libraries and tools have had the prefix "my" for well over 10 years. However, Monty's daughter (some years younger) is also named My. So which of the two gave its name to MySQL is still a mystery, even for us.
そして前期諸説を経て：
The derivation of the name MySQL is not perfectly clear. Our base directory and a large number of our libraries and tools have had the prefix "my" for well over 10 years. However, Monty's daughter (some years younger) is also named My. So which of the two gave its name to MySQL is still a mystery, even for us.
The derivation of the name MySQL is not perfectly clear. Our base directory and a large number of our libraries and tools have had the prefix "my" for well over 10 years. However, Monty's daughter (some years younger) is also named My. Which of the two gave its name to MySQL is still a mystery, even for us.
後期諸説に移行する直前の MySQL 4.1.1-alpha(2003/12/01)では、”perfectly" が削除されるとともに、モンティ氏が co-founder であることの説明が追加された。「もちょっと若い」の記述は残っているので、今回は「前期諸説」に分類した。
The derivation of the name MySQLis not clear. Our base directory and a large number of our libraries and tools have had the prefix "my" for well over 10 years. However, co-founder Monty Widenius'sdaughter (some years younger) is also named My. Which of the two gave its name to MySQL is still a mystery, even for us.
その直後の MySQL 5.0.0-alph(2003/12/22)では、括弧書きの「もちょっと若い」が削除されて後期諸説時代へ入ったことは、前述したとおりである。
The derivation of the name MySQL is not clear. Our base directory and a large number of our libraries and tools have had the prefix "my" for well over 10 years. However, co-founder Monty Widenius's daughter is also named My. Which of the two gave its name to MySQL is still a mystery, even for us.
マニュアルすごい
今回の調査にあたってさまざまなタイミングでのMySQLマニュアルを探す過程で、探り当てた最古のマニュアルが MySQL 3.21.30だ。章立てなどの基本構成や、記述の細かさなど、今見てもまったく見劣りせずしっかりしたマニュアルである。黎明期よりMySQLが多くの人に指示されたのは、充実したマニュアルの存在も大きかったのではないかと推察した。ファウンダーの皆さんの先見の明とご配慮に感服と共に感謝する次第である。
ロードを試みたところ「ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides」というエラーが発生したが、@mita2 さんのブログのおかげで瞬時に解決した。御礼申し上げる。
なお、local_infile は GLOBAL で設定すること。セッションでの設定を試みるとエラーとなる。
mysql> SET local_infile=on;
ERROR 1229 (HY000): Variable 'local_infile'is a GLOBAL variable and should be set with SET GLOBAL
4.クエリ実行
mysql> SELECT prodname, description ,
-> CASEWHEN ver LIKE'3.23%'THEN ver ELSE''END ver323,
-> CASEWHEN ver LIKE'4.0%'THEN ver ELSE''END ver40,
-> CASEWHEN ver LIKE'4.1%'THEN ver ELSE''END ver41,
-> CASEWHEN ver LIKE'5.0%'THEN ver ELSE''END ver50,
-> CASEWHEN ver LIKE'5.1%'THEN ver ELSE''END ver51,
-> releasedate
-> FROM myhist
-> WHERE releasedate isnotnull
-> ORDERBY releasedate;
これにより、冒頭で紹介した結果を得た。
もう少しお遊び
かつてのMySQLは、月に何度もリリースされることもザラにあった。もっとも1ヶ月間でリリースされた回数が多かったのはいつなのだろう、と調べてみた。結果は少々予想していたものと異なり、複数バージョンを同時並行でメンテしていた時期のものが上位に含まれるものとなったが、その中で、 MySQL 3.23 が1ヶ月の間に4度リリースされているのが目に留まる。スピード感と勢いがありましたね、あの頃。
なお、その後の MySQL 5.1 リファレンスマニュアル（現在入手可能なものを含む）では、この部分はバッサリとカットされて、以前(MySQL 3.23/4.0/4.1マニュアルどおり)のシンプルな説明に書き戻されている。beta版のマニュアルを見たモンティ氏から「誰だこれ書いたのは！Myは俺の娘の名前由来だ！」とお叱りを受けたのかもしれない。
