Nice article about 10 SQL optimisations: MySQL, Oracle, SQL Server, DB2, PostgreSQL
Recently I found a very nice article explaining in great
John D K
MySQL: VARCHAR or TEXT for long text fields
In this post:
* Varchar vs Text use cases
* Varchar vs
Oracle refresh statistics on owner/table
Check is it needed update of statistics
If you want
MySQL How to find highest and lowest value
If you want to find the highest or the lowest
C++ - Documentation
*
Official Website https://isocpp.org/
*
Documentation http://devdocs.io/cpp/
Groovy - Documenration
*
Official Website groovy-lang.org
*
Official Documentation http://groovy-lang.
Grails - Documentation++
What is Grails
Grails is a Java based web application
How to Export ER Diagram from MySQL
ER diagrams are very powerful tool which helps Database Administrators,
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;