SimpleDB-school

CREATE DATABASE school;

USE school;

CREATE TABLE users(
UserID INT AUTO_INCREMENT PRIMARY KEY,
FirstName VARCHAR(100),
LastName VARCHAR(100),
Username VARCHAR(50) NOT NULL,
Pass VARCHAR(50) NOT NULL,
Age INT
);

INSERT INTO users (FirstName, LastName, Username, Pass, Age)
VALUES ('Petkan', 'Kirilov', 'petkir', '1234', 28);

INSERT INTO users (FirstName, LastName, Username, Pass, Age)
VALUES ('Ani', 'Vasileva', 'aniv', 'abcd', 17);

INSERT INTO users (FirstName, LastName, Username, Pass, Age)
VALUES ('Kiro', 'Ivanov', 'bakshisha123', 'supermen', 27);

SELECT * FROM users;