-- Oct 5 In-Class Exercise Thread
CREATE DATABASE blog_db;
use blog_db;
CREATE TABLE Entry (
bID INT,
title VARCHAR(200),
body TEXT,
postDate DATETIME,
edited BOOL,
category VARCHAR(200),
PRIMARY KEY(bID)
)
INSERT INTO Entry VALUES
(0, "Feta Sucks", "I hate feta cheese. It's not very good, but still better than blue cheese.", "2022-09-15 09:15:00", False, "Cheese"),
(1, "Follow Up to the last post: American Cheese Sucks Too", "At least it's better than feta.", "2022-09-23 14:57:05", False, "Cheese"),
(2, "I like cheese", "I like many kinds of cheese, like Gruyere, Gouda, Pepperjack, Sharp Cheddar, Goat cheese, just not Feta or Blue cheese varieties.", "2022-10-03 23:59:59", True, "Cheese");
UPDATE Entry SET title="Jaime fromage" WHERE title="I like cheese";
SELECT * FROM Entry WHERE postDate > "2022-09-28 16:00:00" AND postDate < "2022-10-05 16:00:00";
(
Edited: 2022-10-05)
CREATE DATABASE blog_db;
use blog_db;
CREATE TABLE Entry (
bID INT,
title VARCHAR(200),
body TEXT,
postDate DATETIME,
edited BOOL,
category VARCHAR(200),
PRIMARY KEY(bID)
)
INSERT INTO Entry VALUES
(0, "Feta Sucks", "I hate feta cheese. It's not very good, but still better than blue cheese.", "2022-09-15 09:15:00", False, "Cheese"),
(1, "Follow Up to the last post: American Cheese Sucks Too", "At least it's better than feta.", "2022-09-23 14:57:05", False, "Cheese"),
(2, "I like cheese", "I like many kinds of cheese, like Gruyere, Gouda, Pepperjack, Sharp Cheddar, Goat cheese, just not Feta or Blue cheese varieties.", "2022-10-03 23:59:59", True, "Cheese");
UPDATE Entry SET title="Jaime fromage" WHERE title="I like cheese";
SELECT * FROM Entry WHERE postDate > "2022-09-28 16:00:00" AND postDate < "2022-10-05 16:00:00";