MYSQL Archives - Script(s)

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