MySQL Workbench walk-through

🖥️ Open MySQL Workbench

🔍 Search “MySQL Workbench” on your system

🖱️ Click to launch the application

🔐 Connect to MySQL Server

🧱 Click on "Local Instance MySQL"

🔑 Enter your root password

✅ Connection established!

📁 Create a New Database (Schema)

🧩 Click on the Schemas tab (bottom left)

➕ Click the plus icon or run this SQL:

CREATE DATABASE my_database

🎯 Right-click on the database → Set as Default Schema

📄 Create a New Table

🧭 Go to Navigator → Schemas → Tables

🖱️ Right-click on Tables → Create Table

📝 Enter table name: students

🔹 Add columns:

id → INT → Primary Key → Auto Increment

name → VARCHAR(50)

grade → CHAR(2)

💾 Click Apply → Review SQL → Apply → Finish

➕ Insert Data into Table

🧪 Use GUI:

🖱️ Right-click table → Select Rows

📊 Enter values manually → Click Apply

✍️ Use SQL Query:

INSERT INTO students (name, grade) VALUES ('Swastika', 'A');

🔍 Query Your Data

📄 Type in SQL Editor:

SELECT * FROM students;

⚡ Click the Execute button (lightning icon) or press Ctrl + Enter

👁️ View the output in the result grid

✏️ Update or Delete Data

🔁 Update:

UPDATE students SET grade = 'A+' WHERE name = 'Swastika';

❌ Delete:

DELETE FROM students WHERE name = 'Swastika';

💾 Save Your Work

📂 Go to File → Save Script As…

📄 Save your queries as .sql files

🧰 Useful Panels

🧠 SQL Editor – Write and execute queries

🗂️ Schemas Tab – Explore databases and tables

📊 Result Grid – View query output

📈 Status Bar – Shows execution time and connection info

🔄 Reset Workbench Layout (If Needed)

🧼 Go to Help → Reset Workbench Layout