Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

1. Unlike Teradata SQL, a select statement in Oracle must have the from keyword. The dual table can be used if you do not really want to select from a table.

   select …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

https://plot.ly/python/offline/

1. plotly works out-of-box in RStudio, however, not in rmakrdown. This is due to account setup issues. Use plotly in offline mode solves the problem.

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

sudo service mysql restart

mysqladmin -u root -p variables | grep port

mysqladmin --help list the locations of my.cnf.

mysqladmin --help

Python Packages

1. peewee

2. PyMySQL

3. MySQLdb

References

• MySQL Cheat Sheet
• MySQL …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Array with Customized Index

https://docs.julialang.org/en/latest/devdocs/offset-arrays/

https://medium.com/analytics-vidhya/0-based-indexing-a-julia-how-to-43578c780c37

https://www.reddit.com/r/Julia/comments/7btmwr/zero_based_indexing_examples/

References

• Julia
• Julia Studio

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

1. exceltex ... input from excel ...

2. keep each line short, being a part of sentence, this makes it easier to modify LaTeX code

3. bibtex: never skip city for book type!!!

4. bibtex: use volume …

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Oracel Java Tutorial on Collections

ArrayList

1. You can point an element of Array or ArrayList to null, but remember that a null reference cannot invoke any method. For example, if you …