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.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.