MySQL – Literals Table of content In MySQL, literals are fixed values (constants) that can be used in SQL statements such as SELECT, INSERT, UPDATE, and DELETE. We can use a literal in SQL statements without needing to be represented by a variable or an expression. Following are some common MySQL literals: Numeric Literals String […]
Category Archives: mysql
MySQL – Aggregate Functions In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. MySQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the MySQL aggregate functions […]
MySQL – String Functions MySQL – String Functions MySQL string functions are used to manipulate the string values. The following table details the string functions that are available in the MySQL. Sr.No. Name & Description 1 This function returns numeric value of left-most character. 2 This function returns a string representation of the argument. 3 […]