MySQL – Quick Guide MySQL – Introduction What is a Database? A database is a separate application that stores a collection of data. Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds. Other kinds of data stores can also be used, such as files on […]
Category Archives: mysql
MySQL – EXPLAIN Table of content The MySQL EXPLAIN Statement The MySQL EXPLAIN statement is used to provide the execution plan of a query. This statement works similar to the DESCRIBE query; while the DESCRIBE query provides the structure plan of a table, the EXPLAIN statement describes how a query is being executed. You can […]
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 […]