Database Basic - Part 6

Database Basic - Part 6

SQL Script:

USE JadeDb;

DROP TABLE IF EXISTS Scores;

CREATE TABLE IF NOT EXISTS Scores (

id INT AUTO_INCREMENT PRIMARY KEY,

    student_id INT,

    subject_id CHAR(10),

    score FLOAT

);

INSERT INTO Scores (student_id, subject_id, score)

VALUES 

(1, 'PHYSIC', 5),

(2, 'PHYSIC', 7),

(3, 'PHYSIC', 5),

(3, 'MATH', 9),

(2, 'MATH', 8);

SELECT * FROM Scores

Video tutorial

‹‹  Prev: Mysql part 5    Next: MySql part 7  ››