UKTC-SQL

CREATE DATABASE uktc;

USE uktc;

CREATE TABLE students(
id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
firstname VARCHAR(100) NOT NULL,
lastname VARCHAR(100),
age INT,
class INT,
city VARCHAR(100),
email VARCHAR(200)
);

INSERT INTO students
VALUES (1, 'Slavi', 'Trifinov', 32, 171, 'Kaspichan', 'slavkata@uktc.com');

INSERT INTO students (id, firstname, lastname, age, class, city, email)
VALUES (2, 'Kiro', 'Breika', 45, 171, 'V.T.', 'kiro@uktc.com');

INSERT INTO students (firstname, lastname, age)
VALUES ('Ani', 'Borisova', 45);

DELETE FROM students WHERE id = 4;

UPDATE students SET city = 'Novi Pazar' WHERE firstname = 'Slavi';

SELECT * FROM students;