Ben Chuanlong Du's Blog

It is never too late to learn.

Tips on MySQL

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

Rising of the Julia Programming Language

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

Tips on LaTeX

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 …

Collections in Java

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 …

Tips on MS SQL Server

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

  1. convert: 106 - dd mon yyyy, 101 - mm/dd/yyyy

Debug C/C++ Code Using GDB

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

  1. lines use : while functions use ::

  2. use relative path from the executable to implementation files!!!

    b ../../tree.cpp:31 if knot->name()=="GO:0006139"
    
  3. it seems that there is a bug in …