Skip to content

Releases: Skeletus/Crescendo-Database-Engine

Release list

v1.0.0

Choose a tag to compare

@Skeletus Skeletus released this 06 Dec 06:34
dd0662d

You can test this (if errors try to run line by line):

CREATE DATABASE schoolBD

USE schoolBD

CREATE TABLE student (name CHAR(32), gpa FLOAT, place INT)

INSERT INTO student(name, gpa, place) VALUES ('Ana', 15.2, 8)
INSERT INTO student(name, gpa, place) VALUES ('John', 16.2, 7)
INSERT INTO student(name, gpa, place) VALUES ('Mary', 17.5, 6)
INSERT INTO student(name, gpa, place) VALUES ('Yasuo', 15.5, 5)
INSERT INTO student(name, gpa, place) VALUES ('Jack', 20.1, 4)
INSERT INTO student(name, gpa, place) VALUES ('Paul', 19.8, 2)
INSERT INTO student(name, gpa, place) VALUES ('REMOVE', 5.6, 9)
INSERT INTO student(name, gpa, place) VALUES ('Chris', 18.4, 3)
INSERT INTO student(name, gpa, place) VALUES ('Alan', 17.9, 4)

SELECT * FROM student WHERE gpa >= 15 AND gpa <= 19

UPDATE student SET name='Jotaro' WHERE place = 5

DELETE FROM student WHERE name = 'REMOVE'

SELECT * FROM student