MySQL Query Language Extensions

Vitess uses the MySQL client server protocol and query language. While there are some limitations and compatibility mismatches, Vitess also expands on the MySQL query language for Vitess specific usage.

Extensions to the MySQL Query Language

• SHOW has some additional functionality.
• VEXPLAIN is similar to EXPLAIN but specifically for Vitess plans
• You can use a special SELECT query to see the next value from a sequence:

select next value from user_seq;