← Back to MySQL Browser FAQs

How to Run SQL Queries in MySQL Browser

Once connected to your MySQL database, you can run any SQL statement using the built-in query editor.

Running a Query

  1. Type your SQL in the query editor panel on the right side of the screen.
  2. Click the Run button to execute.
  3. Results appear in the Results tab at the bottom, along with the execution time.

Quick Table Inspection

Click any table name in the Tables tab to automatically run SELECT * FROM tablename LIMIT 200 and view the results.

Query History

Every query you execute is saved to the History tab (up to 20 entries). Click any past query to re-run it. History is stored in your browser's IndexedDB and persists across sessions.

Example Queries

SELECT DATABASE(), USER(), VERSION();
SHOW TABLES;
DESCRIBE your_table;
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
SELECT @@version, @@datadir;

Tips

  • Always add LIMIT when exploring large tables
  • Use the execution time to identify slow queries
  • Errors are displayed with the full MySQL error message for easy debugging
  • You can run any SQL — SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, etc.