2022-10-04

Oct 5 In-Class Exercise Thread.

Please post your solutions to Oct 5 In-Class Exercise to this thread.
Best,
Chris
Please post your solutions to Oct 5 In-Class Exercise to this thread. Best, Chris
2022-10-05

-- Oct 5 In-Class Exercise Thread
 create database Blog;
 use Blog;
 create table Entry(varchar title, varchar text, date submission-date);
 insert into Entry("I like chesse", "A lot", 2022-10-05);
 insert into Entry("I hate cheese", "a bit", 2021-10-05);
 insert into Entry("About this exercise", "It's very cheesy", 1234-56-78);
 update Entry
 set title = "Jaime fromage"
 where title = "I like cheese";
 select title, text, submission-date
 from Entry
 where submission-date between "2022-10-05" and "2022-10-28";
(Edited: 2022-10-05)
create database Blog; use Blog; create table Entry(varchar title, varchar text, date submission-date); insert into Entry("I like chesse", "A lot", 2022-10-05); insert into Entry("I hate cheese", "a bit", 2021-10-05); insert into Entry("About this exercise", "It's very cheesy", 1234-56-78); update Entry set title = "Jaime fromage" where title = "I like cheese"; select title, text, submission-date from Entry where submission-date between "2022-10-05" and "2022-10-28";

-- Oct 5 In-Class Exercise Thread
 CREATE DATABASE BLOG;
 use BLOG;
 CREATE TABLE ENTRY (
    title varchar(35) not null,
    desc varchar(200),
    postTime date,
 );
 INSERT INTO ENTRY VALUES 
 ("I like cheese", "I really like it", "2022-09-30"),
 ("Pecorino", "It's pretty salty", "2022-10-04"),
 ("Parm", "I put it on everything", "2022-10-28");
 UPDATE ENTRY
 SET title="Jaime fromage"
 WHERE title="I like cheese";
 select * from ENTRY where postTime between date_sub(now(), INTERVAL 1 WEEK) and now();
(Edited: 2022-10-05)
CREATE DATABASE BLOG; use BLOG; CREATE TABLE ENTRY ( title varchar(35) not null, desc varchar(200), postTime date, ); INSERT INTO ENTRY VALUES ("I like cheese", "I really like it", "2022-09-30"), ("Pecorino", "It's pretty salty", "2022-10-04"), ("Parm", "I put it on everything", "2022-10-28"); UPDATE ENTRY SET title="Jaime fromage" WHERE title="I like cheese"; select * from ENTRY where postTime between date_sub(now(), INTERVAL 1 WEEK) and now();

-- Oct 5 In-Class Exercise Thread
CREATE DATABASE blog
CREATE TABLE Cheese(title varchar(30) PRIMARY KEY NOT NULL UNIQUE, text TEXT, data DATE)
INSERT INTO Cheese VALUES(“Cheddar”, “I LOVE CHEDDAR”, 10/5/22)
INSERT INTO Cheese VALUES(“Gouda”, “I LOVE GOUDA”, 10/5/22)
INSERT INTO Cheese VALUES(“Swiss”, “I LOVE SWISS”, 10/5/22)
INSERT INTO Cheese VALUES(“I like Cheese”, “okay”, 10/5/22)
UPDATE Cheese SET title=“Jaime Fromage” WHERE title=“I like Cheese”
SELECT * FROM Cheese WHERE DATE > 9/28/22
(Edited: 2022-10-05)
CREATE DATABASE blog CREATE TABLE Cheese(title varchar(30) PRIMARY KEY NOT NULL UNIQUE, text TEXT, data DATE) INSERT INTO Cheese VALUES(“Cheddar”, “I LOVE CHEDDAR”, 10/5/22) INSERT INTO Cheese VALUES(“Gouda”, “I LOVE GOUDA”, 10/5/22) INSERT INTO Cheese VALUES(“Swiss”, “I LOVE SWISS”, 10/5/22) INSERT INTO Cheese VALUES(“I like Cheese”, “okay”, 10/5/22) UPDATE Cheese SET title=“Jaime Fromage” WHERE title=“I like Cheese” SELECT * FROM Cheese WHERE DATE > 9/28/22

-- 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";

-- Oct 5 In-Class Exercise Thread
1. CREATE DATABASE blog; USE blog; CREATE TABLE entries(
    post_id int(5) NOT NULL,
    author varchar(30),
    title varchar(50),
    content varchar(1000),
    date_posted DATE,
    PRIMARY KEY(post_id)
);
2. INSERT INTO entries VALUES (0, 'Johnathan', 'I like cheese', 'It's pretty good!', GETDATE()), (1, 'Craig', 'I hate cheese', 'Cheese is gross. Can't stand it.', GETDATE()), (2, 'Walter', 'Cheese is alright', 'I can take it or leave it.', GETDATE());
3. UPDATE entries SET title='Jaime fromage' WHERE title='I like cheese';
4. SELECT * FROM entries WHERE date_posted > DATEADD(week,-1,GETDATE());
1. CREATE DATABASE blog; USE blog; CREATE TABLE entries( post_id int(5) NOT NULL, author varchar(30), title varchar(50), content varchar(1000), date_posted DATE, PRIMARY KEY(post_id) ); 2. INSERT INTO entries VALUES (0, 'Johnathan', 'I like cheese', 'It's pretty good!', GETDATE()), (1, 'Craig', 'I hate cheese', 'Cheese is gross. Can't stand it.', GETDATE()), (2, 'Walter', 'Cheese is alright', 'I can take it or leave it.', GETDATE()); 3. UPDATE entries SET title='Jaime fromage' WHERE title='I like cheese'; 4. SELECT * FROM entries WHERE date_posted > DATEADD(week,-1,GETDATE());

-- Oct 5 In-Class Exercise Thread
CREATE DATABASE blog;
use blog;
CREATE TABLE entry {
    post VARCHAR(2000);
    author VARCHAR(50);
    post_date DATE;
};
INSERT INTO entry VALUES ('I like cheese', 'Nick', '2022-10-05'); INSERT INTO entry VALUES ('I HATE cheese', 'GuyWithNoTaste', '2022-10-05'); INSERT INTO entry VALUES ('I cant eat cheese', 'LactoseIntolerantGuy', '2022-10-05');
UPDATE entry SET post='J aime Fromage' WHERE post='I like cheese';
SELECT * FROM entry WHERE date > '2022-09-28';
CREATE DATABASE blog; use blog; CREATE TABLE entry { post VARCHAR(2000); author VARCHAR(50); post_date DATE; }; INSERT INTO entry VALUES ('I like cheese', 'Nick', '2022-10-05'); INSERT INTO entry VALUES ('I HATE cheese', 'GuyWithNoTaste', '2022-10-05'); INSERT INTO entry VALUES ('I can''t eat cheese', 'LactoseIntolerantGuy', '2022-10-05'); UPDATE entry SET post='J''aime Fromage' WHERE post='I like cheese'; SELECT * FROM entry WHERE date > '2022-09-28';

-- Oct 5 In-Class Exercise Thread
CREATE DATABASE blog; use blog; CREATE TABLE Entry (
	title VARCHAR(128),
	content LONGTEXT,
	post_date DATE,
); INSERT INTO Entry (title, content) VALUES ("I like cheese", "hello", "2022-08-02"), ("entry2, world", "2022-09-05"), ("entry3", "hi", "2022-10-05"); UPDATE Entry SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * from Entry where post_date > '2022-09-28';
CREATE DATABASE blog; use blog; CREATE TABLE Entry ( title VARCHAR(128), content LONGTEXT, post_date DATE, ); INSERT INTO Entry (title, content) VALUES ("I like cheese", "hello", "2022-08-02"), ("entry2, world", "2022-09-05"), ("entry3", "hi", "2022-10-05"); UPDATE Entry SET title = "Jaime fromage" WHERE title = "I like cheese"; SELECT * from Entry where post_date > '2022-09-28';

-- Oct 5 In-Class Exercise Thread
CREATE DATABASE Blog; CREATE TABLE Entry (BlogID INT, Title VARCHAR(255), Body VARCHAR(255), Date DATE); INSERT INTO Entry VALUES (0, "I like cheese", "Cheese is my favorite food.", "2022-09-15"); INSERT INTO Entry VALUES (1, "Cheese is the best", "There's nothing better than cheese.", "2022-10-02"); INSERT INTO Entry VALUES (1, "Do you like cheese?", "I really like cheese.", "2022-10-05"); UPDATE Entry SET Title="Jaime fromage" WHERE BlogID=0; SELECT * FROM Entry WHERE DATE > "2022-09-28";
<nowiki> CREATE DATABASE Blog; CREATE TABLE Entry (BlogID INT, Title VARCHAR(255), Body VARCHAR(255), Date DATE); INSERT INTO Entry VALUES (0, "I like cheese", "Cheese is my favorite food.", "2022-09-15"); INSERT INTO Entry VALUES (1, "Cheese is the best", "There's nothing better than cheese.", "2022-10-02"); INSERT INTO Entry VALUES (1, "Do you like cheese?", "I really like cheese.", "2022-10-05"); UPDATE Entry SET Title="Jaime fromage" WHERE BlogID=0; SELECT * FROM Entry WHERE DATE > "2022-09-28"; </nowiki>

-- Oct 5 In-Class Exercise Thread
CREATE DATABASE BlogDatabse; CREATE TABLE Blog(BlogDate date, BlogTitle varchar, BlogMessage varchar); INSERT INTO Blog("2022-10-5", "Cheese1", "I like cheese"); INSERT INTO Blog("2022-10-5", "Cheese2", "I like cheese2"); INSERT INTO Blog("2022-10-5", "Cheese3", "I like cheese3"); UPDATE Blog SET BlogTitle = "Jaime fromage" WHERE BlogTitle='I like cheese'; SELECT BlogDate, BlogTitle, BlogMessage FROM BLOG WHERE BlogDate BETWEEN '2022-10-05'AND '2022-10-19';
CREATE DATABASE BlogDatabse; CREATE TABLE Blog(BlogDate date, BlogTitle varchar, BlogMessage varchar); INSERT INTO Blog("2022-10-5", "Cheese1", "I like cheese"); INSERT INTO Blog("2022-10-5", "Cheese2", "I like cheese2"); INSERT INTO Blog("2022-10-5", "Cheese3", "I like cheese3"); UPDATE Blog SET BlogTitle = "Jaime fromage" WHERE BlogTitle='I like cheese'; SELECT BlogDate, BlogTitle, BlogMessage FROM BLOG WHERE BlogDate BETWEEN '2022-10-05'AND '2022-10-19';
[ Next ]
X