Hire Expert
MySQL Developers

-- Create a new database
CREATE DATABASE IF NOT EXISTS demo_db;
USE demo_db;

-- Create a table named 'employees'
CREATE TABLE IF NOT EXISTS employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    position VARCHAR(100),
    salary DECIMAL(10, 2),
    hired_date DATE
);

-- Insert data into 'employees'
INSERT INTO employees (name, position, salary, hired_date) VALUES
('Alice', 'Developer', 70000, '2018-04-10'),
('Bob', 'Designer', 60000, '2019-01-15'),
('Charlie', 'Manager', 80000, '2017-09-23');

-- Select all records from 'employees'
SELECT * FROM employees;

-- Update a record
UPDATE employees SET salary = 75000 WHERE name = 'Alice';

-- Select a specific record
SELECT * FROM employees WHERE name = 'Alice';

-- Delete a record
DELETE FROM employees WHERE name = 'Bob';

-- Select all records to show the update and delete effects
SELECT * FROM employees;

-- Drop the table if you want to clean up
-- DROP TABLE employees;

-- Drop the database if you want to clean up
-- DROP DATABASE demo_db;