yudisentosa / SBDProjectSchool

0 stars 0 forks source link

Table - extracurricular #14

Closed marcelinalinaa closed 3 years ago

marcelinalinaa commented 3 years ago

DROP TABLE IF EXISTS extracurricular; CREATE TABLE extracurricular( extracurricular_id VARCHAR(6) NOT NULL PRIMARY KEY ,extracurricular_name VARCHAR(12) NOT NULL ); INSERT INTO extracurricular(extracurricular_id,extracurricular_name) VALUES ('EXC001','Basketball'); INSERT INTO extracurricular(extracurricular_id,extracurricular_name) VALUES ('EXC002','Soccer'); INSERT INTO extracurricular(extracurricular_id,extracurricular_name) VALUES ('EXC003','Badminton'); INSERT INTO extracurricular(extracurricular_id,extracurricular_name) VALUES ('EXC004','Science Club'); INSERT INTO extracurricular(extracurricular_id,extracurricular_name) VALUES ('EXC005','Modern Dance');