This document aggregates snippets that I found useful when working in bioinfromatics. It is work in progress and I will extend it as needed. It is mainly in form of toy examples or pseudcode. Please adjust it accodring to your needs.
mysql --user=root -p
/*get preview */
show databases;
USE <some_database>;
show tables;