📄️ Introduction
MySQL is an open-source Relational Database Management System (RDBMS).
📄️ Installation
When starting with MySQL, you have two main options for installation:
📄️ MySQL Workbench
MySQL Workbench is a graphical user interface (GUI) tool provided by Oracle for interacting with MySQL databases. Instead of typing all SQL commands in the command line, It gives you a visual environment to:
📄️ MySQL Server Connection
The MySQL server runs as a service (daemon) in the background.
📄️ MySQL Client Tools
When you install MySQL, you get access to different client tools that allow you to interact with the MySQL server.
📄️ Core Concepts
- Database: A database is an organized collection of structured data, stored and managed so that it can be efficiently accessed, retrieved, and updated.
📄️ Data Types
Numeric
📄️ Constraints
Constraints are rules applied to table columns to enforce data integrity and consistency. They ensure that the data stored in a table adheres to certain rules.