MySQL – Today Date Table of content Generally, the date is represented using three values: date, month, and year. Dates have many possible variations, all of which depend on several inconsistency factors. DD/MM/YYYY, For instance – 04/04/2024 YYYY/MM/DD, For instance – 2024/04/27 DD-MM-YYYY, For instance – 04-04-2024 MySQL Today”s Date We have several built-in functions […]
Category Archives: mysql
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 […]
MySQL – On Delete Cascade Table of content The MySQL ON DELETE CASCADE Constraint The MySQL ON DELETE CASCADE constraint ensures that when a row in the parent table is deleted, all related rows in the child table are automatically deleted as well. This constraint helps maintain referential integrity between two tables that are connected […]