MySQL – Arithmetic Operators MySQL – Arithmetic Operators Arithmetic operators in MySQL are tools for performing mathematical calculations, similar to how we use them in basic math. They allow us to manipulate numeric values in your database, just like we would in simple math problems. Following are the arithmetic operators in MySQL − Sr.No. Name […]
Category Archives: mysql
MySQL – Common Table Expression (WITH) Table of content The MySQL Common Table Expression The MySQL Common Table Expression (CTE) is a temporary result-set or table that exists for the duration of a single query. We can use the CTEs to reference the result-set within the context of a single SELECT, UPDATE, INSERT, DELETE, CREATE, […]
MySQL – BLOB Table of content Many user applications require the storage of different types of data, including text, images, files, and more. Using BLOBs in a MySQL database allows you to store all these types of data within the same database, eliminating the need for a separate file system. The MySQL BLOB Data Type […]