EasyEnv
Engineering/Courses/Catalog/MySQL/The mysql CLI and First Commands
MySQL
IntermediateLesson 2 of 1325 min · hands-on

The mysql CLI and First Commands

Part of the MySQL course

The last lesson was all talk: what MySQL is, where it came from, why it exists. None of that lets you actually ask a server anything. A database server that nobody can reach is just a process burning memory. To do anything useful with MySQL, you need a way to type a question and get an answer back, and that means a client: a program that connects to the server, sends it your commands, and prints whatever comes back.

The client you will use for the rest of this course is called mysql. It is a small program that speaks the MySQL network protocol on your behalf and gives you a prompt where you can type one query at a time and watch the result. It is not fancy, and that is the point: almost every tutorial, every piece of documentation, and every other tool you will meet later assumes you are comfortable at this prompt first. ...

Want to learn MySQL The mysql CLI and First Commands in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through The mysql CLI and First Commands hands-on with an AI tutor that knows your code.

Start this lessonThe mysql CLI and First Commands

What you'll learn

  • Mysql client
  • Connecting with -u and -p
  • SHOW DATABASES
  • USE
  • SHOW TABLES
  • DESCRIBE
  • Exiting the client
  • Semicolons and multiline queries

Read this lesson in your language

All lessons in this course

13 lessons
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

The mysql CLI and First Commands - MySQL (English) | Engineering Courses