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, […]
Category Archives: mysql
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 […]
MySQL – UUID Table of content The MySQL UUID function The MySQL UUID() function is used to generate “Universal Unique Identifiers” (UUIDs) in accordance with RFC 4122. UUIDs are designed to be universally unique, even when generated on different servers. The UUID is generated using a combination of the current timestamp, the unique identifier of […]