How to Execute a SQL Query on Your Database

The SQL Query page in the Nobregas MySQL Panel lets you run any supported SQL statement directly on your database — no external tools or terminal access needed. Write your query, click execute, and see results instantly in a formatted table.

Opening the SQL Query Page

1. Log in at mysql.nobregas.org.
2. Click SQL Query in the top navigation bar.
3. The query editor loads with a text area for your SQL and controls for execution.

Running Your First Query

1. Select a database from the dropdown at the top. You must choose a database before running any query.
2. Type your SQL in the query editor. For example:

SELECT * FROM users LIMIT 10;

3. Click the Execute button (or press the keyboard shortcut).
4. Results appear below the editor in a formatted table.

Reading the Results

After execution, the panel displays:

• Result table — Columns and rows returned by your query.
• Row count — How many rows were returned or affected.
• Execution time — How long the query took to run.
• Status message — Success confirmation or error details.

For queries that modify data (INSERT, UPDATE, DELETE), you see the number of affected rows instead of a result table.

Types of Queries You Can Run

Data Queries

SELECT * FROM products WHERE price > 50;
INSERT INTO logs (message, created_at) VALUES ('Test', NOW());
UPDATE users SET active = 1 WHERE id = 5;
DELETE FROM sessions WHERE expires_at < NOW();

Structure Queries

SHOW TABLES;
DESCRIBE users;
SHOW CREATE TABLE orders;

Information Queries

SELECT COUNT(*) FROM users;
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();

Query Editor Features

• Multi-line support — Write complex queries across multiple lines.
• Database selector — Choose which database to run your query against before executing.

Error Handling

If your query has a syntax error or fails, the panel shows:

• The MySQL error code and message.
• The specific part of the query that caused the issue.

Common errors include missing semicolons, misspelled table names, and column reference errors. Check the error message carefully — MySQL error messages are usually descriptive enough to pinpoint the problem.

Security Restrictions

For security, certain dangerous operations are blocked, including:

• GRANT and REVOKE statements (use the UI instead).
• DROP DATABASE (use the Databases page).
• System-level commands that affect the server.

If a query is blocked, the panel displays a clear message explaining why.