MySQL + SQL · Lesson 31
MySQL Setup and First Commands
Getting Started with MySQL
To start, install MySQL Server (and optionally MySQL Workbench or use XAMPP for a quick local setup). Then connect and run your first commands.
Your First Commands
SHOW DATABASES; -- list databases
CREATE DATABASE school; -- make one
USE school; -- select it
SHOW TABLES; -- list tables in it
Tip
On Windows, XAMPP gives MySQL + phpMyAdmin in one click — great for students and PHP projects.
Summary
- Install MySQL Server (or XAMPP for local dev).
- First commands: SHOW DATABASES, CREATE DATABASE, USE, SHOW TABLES.
💻 Live Code Editor
Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.
💻 Live Code Editor
Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें.
Agar load na ho to naye tab mein kholें.