MariaDB – Quick Guide MariaDB – Introduction A database application exists separate from the main application and stores data collections. Every database employs one or multiple APIs for the creation, access, management, search, and replication of the data it contains. Databases also use non-relational data sources such as objects or files. However, databases prove the […]
Category Archives: mariadb
MariaDB – Useful Functions This chapter contains a list of the most frequently used functions, offering definitions, explanations, and examples. MariaDB Aggregate Functions Most frequently used aggregate functions are given below − Sr.No Name & Description 1 COUNT It counts the number of records. Example − SELECT COUNT(*) FROM customer_table; 2 MIN It reveals the […]
MariaDB – Like Clause The WHERE clause provides a way to retrieve data when an operation uses an exact match. In situations requiring multiple results with shared characteristics, the LIKE clause accommodates broad pattern matching. A LIKE clause tests for a pattern match, returning a true or false. The patterns used for comparison accept the […]