Database basic part 9: modify database statements

Sql script

SET SQL_SAFE_UPDATES = 0;

USE JadeDb;


DROP TABLE IF EXISTS Scores;


CREATE TABLE IF NOT EXISTS Scores (`name` VARCHAR(30),
                                          score FLOAT);


INSERT INTO Scores (`name`, score)
VALUES ('Join', 5),
       ('Join', 10),
       ('Alley', 3),
       ('Robert', 6),
       ('Alley', 8),
       ('Join', 8),
       ('Robert', 4),
       ('Jade', 2);

Video tutorial