Read sample rows
The learners table contains id, name, and score columns.
SELECT * FROM learners;Online MySQL
Practice MySQL online with SQL queries and database exercises. Start with SELECT expressions, then explore tables, joins, and schema design in a real database lab.
- Free online practice
- Real LabEx environments
- No installation
- SELECT queries
- Tables and joins
- Database design
MySQL Shell· Ready
Welcome to the LabEx MySQL Shell.
Press Enter to run your first command. Type help for session commands.
Commands run locally in your browser.Enter run · ↑/↓ history · Tab complete
Start here
Quick Start with MySQL Playground
Load a task into the terminal, then press Enter to see the result. Each example works in the introductory session on this page.
Choose columns
Return only the columns you need.
SELECT name, score FROM learners;Filter rows
Find learners whose score is at least 80.
SELECT * FROM learners WHERE score >= 80;Sort results
Read the sample rows from highest score to lowest.
SELECT * FROM learners ORDER BY score DESC;Count rows
Count the current rows in the table.
SELECT COUNT(*) FROM learners;Insert a learner
Add a row and run the first query again to inspect it.
INSERT INTO learners (name, score) VALUES ('Sam', 88);Update a score
Change Alex’s score in the sample table.
UPDATE learners SET score = 95 WHERE name = 'Alex';Delete a learner
Remove the inserted learner; this is also safe to try before inserting.
DELETE FROM learners WHERE name = 'Sam';No setup needed
How the MySQL Playground Works
Practice MySQL online with SQL queries and database exercises. Start with SELECT expressions, then explore tables, joins, and schema design in a real database lab.
Start with the short command exercises above. When you are ready for a project, open the linked LabEx lab to work with real tools in an online Linux environment, with step-by-step guidance and immediate feedback.
Keep learning
Learn MySQL with Hands-On Labs
Build on your MySQL experiments with a structured skill tree. Explore the skills, choose a guided lab, and practice each concept in an online environment.
Online MySQL FAQ
What SQL skills can I practice with MySQL?
Start with queries and table operations, then use the MySQL Skill Tree for database setup and data-management tasks. Sign in to the linked lab for a real MySQL server.
Is the MySQL Playground free?
The introductory exercises are free. Sign in for a complete LabEx environment; session duration and resources depend on your lab and plan.
Do I need to install software?
No local installation is required. Sign in and open the lab in a modern browser. Follow the lab instructions to configure software inside the environment.
Where can I use more commands and features?
This preview supports a limited command set. Sign in and launch the MySQL lab for more commands, packages and services. Available software and permissions depend on the selected lab.
How do I continue learning MySQL?
Follow the MySQL Skill Tree for guided labs and challenges. Practice regularly, inspect command output and ask Labby for help.
Related Playgrounds
View all playgrounds →
Your next step
Ready to practice MySQL?
Continue with real tools, guided labs, and Labby assistance.