SQL Editor
The SQL editor runs SQLite in your browser. It does not connect to your XAMPP MySQL server or send your statements to the website's database. Each Run creates a fresh temporary database.
Understand the idea
Lesson links load the sample schema, data, and the current query as editable text. Nothing runs until you choose Run. Setup statements may print completion messages before the query rows. Changes exist only during that run, so include all dependent statements in one script. For phpMyAdmin, use the separately supplied MySQL seed and the dialect notes.
Where to try it
Run this example in the SQL playground. The lesson link loads the shop tables and sample rows before this query. Select Run when you are ready. Every run starts fresh, so your changes do not affect the website or a previous run.
SQLite sample data · MySQL / MariaDB sample data · See the sample tables
A worked example
SELECT 'Ready to learn SQL' AS message;
SELECT COUNT(*) AS sample_products FROM products;
Read the result
After the setup statements, the result shows Ready to learn SQL and a product count of 4. Clearing the editor removes the text, and running again starts from an empty database unless your script creates the tables.
Try one change
Open the example in the playground, run it, change the message, and run again. Confirm that importing a lesson never executes it automatically.