🗄️ How to Use the Database Testing Widget
- SELECT Queries: Retrieve and analyze data from the test database
- JOIN Operations: Test complex queries with multiple tables
- Aggregate Functions: Use COUNT, SUM, AVG, MAX, MIN for data analysis
- WHERE Clauses: Filter data with conditions and operators
- ORDER BY & LIMIT: Sort and limit result sets
💡 Tip: Use the example queries to quickly test common database operations. The widget displays results in a formatted table for easy analysis.
⚠️ Security: Only SELECT queries are allowed. INSERT, UPDATE, DELETE, DROP, and other modification queries are blocked for security. Maximum 10 queries per session.
📊 Database Schema
users
Columns: id, username, email, full_name, age, country, created_at
products
Columns: id, name, category, price, stock_quantity, description
orders
Columns: id, user_id, product_id, quantity, order_date, status
reviews
Columns: id, product_id, user_id, rating, comment, review_date
Ready to execute queries...