course.txt

CREATE DATABASE IF NOT EXISTS coursetest DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
use coursetest;
CREATE TABLE course 
(
	student  VARCHAR(50)  NOT NULL,
  	class    VARCHAR(50)  NOT NULL
);

INSERT INTO course(student,class) VALUES ('A','Math');
INSERT INTO course(student,class) VALUES ('B','English');
INSERT INTO course(student,class) VALUES ('C','Math');
INSERT INTO course(student,class) VALUES ('D','Biology');
INSERT INTO course(student,class) VALUES ('E','Math');