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 – Date and Time Functions In MySQL, we have a set of functions using which we can manipulate the date and time values. Following are the MySQL date time functions − Sr.No. Name & Description 1 This function adds two given dates 2 This function adds given time values 3 This function converts from […]