zfDmkMHH

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