MySQL + SQL · Lesson 1
Mysql Workbench
What is MySQL Workbench?
MySQL Workbench is the official free visual tool to design, manage and query MySQL databases without typing every command. Great for beginners who prefer a GUI.
What You Can Do
- Connect to a MySQL server with a few clicks.
- Create databases and tables visually.
- Write and run SQL in a query editor with syntax highlighting.
- Design ER diagrams (visual database models).
- Import/export data and backups.
Getting Started
- Download MySQL Workbench from dev.mysql.com.
- Open it and click the + to add a connection (host: localhost, user: root).
- Enter your password and connect.
- Use the query tab to run SQL:
SELECT * FROM students;
Workbench vs phpMyAdmin
Workbench is a desktop app with ER-diagram design tools; phpMyAdmin runs in the browser and ships with XAMPP. Both manage MySQL — pick whichever you find comfortable.
Summary
- MySQL Workbench is the official visual GUI for MySQL.
- Create tables, run queries and design ER diagrams without the command line.
💻 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ें.