MySQL query to do nothing (like pass)

Question

Many languages have a construction that fills a syntactic position of a statement but has no effect: pass in Python, \relax in TeX, CONTINUE in Fortran, ; in C and Perl.

What is its equivalent in MySQL? That is, a query that would be syntactically correct but have no effect -- apart from confusing expressions like SELECT * FROM table LIMIT 0.

This is useful when the queries are generated automatically and at some point the generation procedure is expected to generate a query but there is no action to do.

Answer 1

When doing from cli client you can also just call the quit function as you enter like this:

mysql -e '\q'

Answer 2

DO 0; is another option for MySQL No-op.

Answer 3

First what comes to mind is just SELECT null or something similar.

Edit: Unlike SELECT null, set @noop = null does nothig

Answer 4

This query:

SELECT 1 FROM DUAL WHERE false

or simpler in MySql 8.0+:

SELECT 1 WHERE false

return nothing, if this is what you mean when you say no effect.