Free tutorials in Hindi & English Clean code examples with output Mobile friendly learning
MySQL + SQL · Lesson 32

MySQL Command Line Basics

Using the MySQL CLI

The MySQL command-line client lets you run SQL directly in the terminal.

Connecting

mysql -u root -p
# enter your password when asked

Useful CLI Commands

CommandDoes
SHOW DATABASES;list databases
USE school;select a database
SHOW TABLES;list tables
DESC students;show table structure
\q or EXIT;quit

Summary

  • Connect with mysql -u root -p.
  • USE selects a DB; SHOW/DESC explore it; EXIT quits.
🔗

Share this topic with a friend

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

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

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

\n

💻 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ें.