Description\n-----------\n\nYou can use DUAL instead of a table name in situations where no tables are referenced, such as the following SELECT statement:\n\n``sql\nSELECT 1 + 1 FROM DUAL;\n+-------+\n| 1 + 1 |\n+-------+\n|     2 |\n+-------+\n`\n\nDUAL is purely for the convenience of people who require that all SELECT statements should haveFROM and possibly other clauses. MariaDB ignores the clauses. MariaDB does not require FROM DUAL if no tables are referenced.\n\nFROM DUAL could be used when you only SELECT computed values, but require a WHERE clause, perhaps to test that a script correctly handles empty resultsets:\n\n`sql\nSELECT 1 FROM DUAL WHERE FALSE;\nEmpty set (0.00 sec)\n``\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/dual