jAmxYHQr

1DROP DATABASE IF EXISTS se266;
2CREATE DATABASE se266;
3
4
5use se266;
6CREATE TABLE users (
7  course_id        INT(11)        NOT NULL   AUTO_INCREMENT,
8  course_name       VARCHAR(50),
9  student_id     VARCHAR(50)    NOT NULL,
10  course_credits    INT(11)    NOT NULL,
11  PRIMARY KEY (course_id)
12);
13-- create the users and grant priveleges to those users
14GRANT SELECT, INSERT, DELETE, UPDATE
15ON se266.*
16TO se266_user@localhost
17IDENTIFIED BY 'pwd';
18
19INSERT INTO users (course_id, course_name, student_id, course_credits)
20VALUES ('1234', 'PHP', '1234', '7');
21use se266;
22SELECT * FROM users;