Skip to content

queries.md

Latest commit

 

History

History
35 lines (31 loc) · 539 Bytes

queries.md

File metadata and controls

35 lines (31 loc) · 539 Bytes

Query

Create table

CREATE TABLE employees (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    email VARCHAR(150),
    salary DECIMAL(10,2),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Insert data

INSERT INTO employees (name, email, salary)
VALUES ('John Doe', 'john@example.com', 50000);

Retrieve data

SELECT * FROM employees;

Update data

UPDATE employees
SET salary = 55000
WHERE id = 1;

Delete data

DELETE FROM employees
WHERE id = 1;