How to Export ER Diagram from MySQL
ER diagrams are very powerful tool which helps Database Administrators,
John D K
Remote Connection to MySQL with SSH tunnel to Ubuntu 16
Simple connection with terminal
mysql -u {username} -p{password} -h
How to rename MySQL schema - the proper way
Renaming a MySQL schema depends on several constraints:
* database size;
Full back up, update and reinstall of MySQL Ubuntu 16
Back up MySQL manually or by script
Manual back up
Oracle, MySQL - select max and return multiple values
A common problems in SQL are to find the data
Laws of Computer Programmers
Funny laws of the 'real' programmer. If you
Oracle indexes - create, rebuild, select, drop
Select all indexes by status
Check indexes by status by
SQL concatenate examples
Concatenation basics
*
concatenation functions:
* Oracle - concat
* MySQL - concat
SQL Count not null values in every table column
In this post:
* SQL count null and not null values
Popular programming languages 2017 and trends
Many popular sites publish analysis and statistics about which languages