What's the best MySQL alternative to dual?

I remember using Select 1 from dual in oracle and just select 1; in mysql. So I think you just try without a table reference.

This was to verify connectivity so not sure if it applies in your case.

You are permitted to specify DUAL as a dummy table name in situations where no tables are referenced:

SELECT 1+1;

SELECT 1 + 1 FROM DUAL;

Related