My SQL String Functions Part2

 




















































































































































































































































Comments

Post a Comment

Popular posts from this blog

MySQL Maths Functions

Image
  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...
Read more