MYSQL Archives - Script(s)

Install MySQL 8 using Docker easily

December 29, 2018January 26, 2019 gchandra 0 Comments docker, installation, MySQL

In my previous article we discussed about installing MySQL 8 using Docker in several steps. Now lets see how it

Install MySQL 8 using Docker

December 29, 2018December 29, 2018 gchandra 0 Comments docker, MySQL, workbench

Installing and using MySQL with Docker is simple and straight forward. Step 1: Get latest MySQL docker image$ docker pull

Database MYSQL

Install Community Edition of MySQL on Centos 7 / RHEL 7

June 25, 2018June 25, 2018 gchandra 0 Comments centos, installation, MySQL, rhel, secure installation, temporary password

Simple steps to install Community Edition MySQL on Centos 7 / RHEL 7 7 simple steps to install MySQL on

Database MYSQL SQL Server

SQL custom sorting

June 25, 2018June 25, 2018 gchandra 0 Comments field, MySQL, mysql custom sort, SQL Server

What is SQL Custom Sorting ? In SQL queries mostly there will be a need to sort data either in

Database Hive MYSQL SQL Server

Multiplying two positive numbers resulting in a negative number

June 23, 2018June 25, 2018 gchandra 0 Comments arithmetic overflow, bigint, hive, MySQL, SQLServer

Weird multiplication Error What would you do when multiplying two positive numbers resulting in a negative result ? If its

Database MYSQL

MySQL – Select statement parsing order

June 8, 2018June 25, 2018 gchandra 0 Comments execution order, parse order, select

To write better MySQL queries, its important to know the parsing order of Select statement. The order is as follows.

MYSQL

MySQL client ran out of memory

January 17, 2018 gchandra 0 Comments Cursor, HY000, Memory, MySQL, ODBC, SSIS

Error Message : Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.1.22-MariaDB]MySQL client ran