Database Basics

This page demonstrates a minimalist setup for managing personnel records, showcasing primary key structures, data insertion, and basic table retrieval.

---

1. Schema Definition & Data Insertion

CREATE DATABASE XYZ;
USE XYZ;

CREATE TABLE EMPLOYEE (
    ID INT PRIMARY KEY,
    NAME VARCHAR (50),
    SALARY INT NOT NULL
);

INSERT INTO EMPLOYEE
(ID, NAME, SALARY)
VALUES
(1, "ADAM", 25000),
(2, "BOB", 30000),
(3, "CASEY", 40000);

2. Data Retrieval

SELECT * FROM EMPLOYEE;