MySQL

 

 

 

                                                                        ********************

String Functions  A string function is a function that takes a string value as an input and the return value (output) can be a string / numeric / character value.  In SQL Server, there are many built-in string functions that can be used by developers say almost 50.  Sytnax - string_function_name(argument1,[arg2, arg3...]); Why String Functions - They allow us to alter the individual characters in a string, compare strings, search strings, to extract substrings, copy of a string. You can also use these SQL String Functions to convert strings to lowercase or uppercase. 1. UCASE(string) / UPPER(string) - will convert the lower-case alphabets into upper case of the string in the argument value. mysql> SELECT UPPER(‘MAJOR PRATAP’); ?? mysql> SELECT UPPER(‘20000.00’); ?? 20000.00 mysql>SELECT UPPER(SalePrice)FROM SALES; ?? 2. LOWER(string) OR LCASE(string) - will convert the upper-case alphabets into lower case of the string specified in the argument ...

  Revision of database concepts and SQL commands covered in class XI  Scalar Functions - Numeric functions: POWER (), ROUND (), MOD ().  String /  Text functions: UCASE ()/ UPPER (), LCASE ()/ LOWER (), MID ()/ SUBSTRING () /SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM ().  Date Functions: NOW (), DATE (), MONTH (), MONTHNAME (), YEAR (), DAY (), DAYNAME () Aggregate Functions - MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*).  Querying and manipulating data using Group by, Having, Order by.  Working with two tables using equi-join Querying & SQL ( Continue )  Syntax  – pre-defined set of rules which tell how to write a command / statement for error free execution. (Every language has its own library where all the keywords – statements / functions / methods / attributes / modules are pre-defined with their structure(syntax).  So during the translation phase (execution) the translator (assemble...