What is a SQL Statement That Will Work for Any MySQL Database?

Problem scenario
You want to test connectivity to a database. But you do not know anything about the database beyond its connection information. What SQL statement is universal and guaranteed to work?

Solution
show databases;

Leave a comment

Your email address will not be published. Required fields are marked *