MySQL – Installation, Database, and CRUD Operations

What is MySQL?

MySQL is an open-source Relational Database Management System (RDBMS) that uses SQL (Structured Query Language) to store, organize, and manage data. It is widely used for web applications, enterprise software, and data-driven projects.

Why use MySQL?

Free and open-source, with enterprise support available
Fast, reliable, and highly scalable
Supports large databases with millions of records
Compatible with many programming languages (PHP, Java, Python, etc.)
Strong security features with user permissions

Step 1: Download and Install MySQL

Download the MySQL Installer from https://dev.mysql.com/downloads/installer/. Choose Full Setup, set a root password, and complete installation.

Step 2: Open MySQL Command Line

mysql -u root -p

Enter password: ******

Step 3: Create a Database

-- Create a new database named 'company_db'
CREATE DATABASE company_db;

-- Display all available databases
SHOW DATABASES;

+--------------------+
| Database |
+--------------------+
| company_db |
| information_schema |
+--------------------+

Step 4: Create a Table

-- Use the newly created database
USE company_db;

-- Create an 'employees' table with id, name, department, and salary fields
CREATE TABLE employees (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  department VARCHAR(50),
  salary DECIMAL(10,2)
);

-- Show tables to confirm creation
SHOW TABLES;

+----------------+
| Tables_in_company_db |
+----------------+
| employees |
+----------------+

Step 5: CRUD Operations

Insert Data

-- Insert three Indian employees
INSERT INTO employees (name, department, salary)
VALUES ('Ravi Kumar', 'HR', 55000.00),
       ('Anjali Sharma', 'IT', 65000.00),
       ('Amit Verma', 'Finance', 70000.00);

Update Data

-- Increase Ravi Kumar's salary to 60000
UPDATE employees
SET salary = 60000.00
WHERE name = 'Ravi Kumar';

Delete Data

-- Remove Anjali Sharma from records
DELETE FROM employees
WHERE name = 'Anjali Sharma';

Final Select Query

-- Display all remaining employee records
SELECT * FROM employees;

+----+------------+------------+----------+
| id | name | department | salary |
+----+------------+------------+----------+
| 1 | Ravi Kumar | HR | 60000.00 |
| 3 | Amit Verma | Finance | 70000.00 |
+----+------------+------------+----------+

Previous Next