Skip to content

v1.0.0

Latest

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