The Nobregas MySQL Panel automatically logs every SQL query you execute on the server for security and audit purposes. This means your past queries are tracked and recorded, helping you maintain a record of database operations.
How Query Tracking Works
Every time you execute a query on the SQL Query page, the panel records:
- The SQL statement — The full query text that was executed.
- Timestamp — When the query was run.
- Database — Which database the query was executed against.
- Status — Whether the query succeeded or failed.
- Execution time — How long the query took.
- Rows affected — How many rows were returned or modified.
This data is stored securely on the server, associated with your user account.
Keeping Track of Your Queries
Since query history is tracked server-side, here are practical tips for managing your queries day-to-day:
Save Important Queries Locally
Keep a local .sql file or text document with queries you use frequently. This gives you instant access to your most important statements without needing to rewrite them.
Use Comments in Your SQL
Add comments to remind yourself what a query does:
-- Monthly active users report
SELECT COUNT(*) FROM users WHERE last_login > DATE_SUB(NOW(), INTERVAL 30 DAY);
Check Query Results Immediately
After executing a query, the results panel shows row count, execution time, and a formatted table. Review these carefully before navigating away.
Query History Scope
- Your query history is personal — other users cannot see your queries.
- History is stored per account, not per database.
- Both successful and failed queries are logged.
Tips
- Keep a query notebook — Store important queries in a local file so you can re-run them anytime.
- Review results before destructive operations — Run a SELECT first to see what will be affected before running DELETE or UPDATE.
- Track changes — Note what queries you ran and when, especially on production databases.
