Category Archives: SQL

Some Interesting Facts About MySQL

MySQL is a relational database management system (RDBMS) based on SQL- Structured Query Language and is free and open source.MySQL was created by MySQL AB, a Swedish company in 1995 which was later acquired by Sun Microsystems in 2008. MySQL is easy to use and fast. It is one of the most famous open source databases and it… Read More »

Single row character functions

Single row character function are those function which accepts character values as arguments and return either a numeric or character values. These are two types: Case Manipulation Character Manipulation These are explained as following below. 1. Case Manipulation: It accept the character values and return the character value. UPPER(string1): Converts all letters of string1 into upper case. LOWER(string1):… Read More »