Getting Started with MySQL: Creating a Database, Table, and Performing Basic SQL Queries

MySQL is a popular relational database management system, perfect for handling data and performing a variety of tasks. In this blog, we'll walk through the process of creating a database, setting up a table, inserting records, and using basic SQL queries to manage the data.

---

Step 1: Creating a Database

To begin, we’ll first create a database using the CREATE DATABASE statement.

CREATE DATABASE employeeDB;

After creating the database, we need to select it for further actions:

USE employeeDB;

---

Step 2: Creating a Table

Next, we'll create a table to store employee records. The table will include columns for id, name, department, position, and salary.

CREATE TABLE employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    department VARCHAR(50),
    position VARCHAR(50),
    salary DECIMAL(10, 2)
);

---

Step 3: Inserting Records

Now, let’s insert some data into our employees table:

INSERT INTO employees (name, department, position, salary)
VALUES
('John Doe', 'IT', 'Developer', 60000.00),
('Jane Smith', 'HR', 'Manager', 75000.00),
('Mark Taylor', 'Finance', 'Analyst', 55000.00),
('Lucy Brown', 'Marketing', 'Executive', 50000.00),
('Peter Johnson', 'Sales', 'Lead', 65000.00);

---

Step 4: Basic SQL Queries

Now that we have our data, let's run some basic queries.

• Retrieve All Records: This query fetches all the records from the employees table.

SELECT * FROM employees;

• Update a Record: Suppose we want to increase Lucy's salary by 5%.

UPDATE employees
SET salary = salary * 1.05
WHERE name = 'Lucy Brown';

• Retrieve Employees from a Specific Department: To find all employees working in the IT department:

SELECT * FROM employees
WHERE department = 'IT';

---

Conclusion

You now have a basic understanding of how to create a MySQL database, set up a table, insert data, and run simple queries to manipulate and retrieve data. These commands form the foundation of more advanced database operations, which can be essential for any project involving data storage and management.

Stay tuned for more advanced SQL concepts in the upcoming blogs!

---

Now you're all set to start using MySQL for your projects. Feel free to experiment with more queries and operations as you grow your database skills.

---