Yioop - PHP Search Engine

-- 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", "I love cheese.", "2022/09/15"); INSERT INTO Entry VALUES(1, "Cheese is amazing.", "Cheese is great.", "2022/10/02"); INSERT INTO Entry VALUES (1, "Cheese is cheesy.", "There are many types of cheese.", "2022/10/05"); UPDATE Entry SET Title="Jaime fromage" WHERE BlogID = 0; SELECT * FROM Entry WHERE DATE > "2022/09/28";

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE Blog; USE blog; CREATE TABLE Entry (BlogID INT, Title VARCHAR(255), Body VARCHAR(255), Date DATE); INSERT INTO Entry VALUES (0, "I like cheese", "Cheese tastes good.", "2022-09-28"); INSERT INTO Entry VALUES (1, "Whaat's your favorite cheese?", "Mine is cheddar.", "2022-10-02"); INSERT INTO Entry VALUES (2, "Goat cheese is overrated", "It shouldn't even be called cheese.", "2022-10-05"); UPDATE Entry SET Title="Jaime fromage" WHERE Title="I like cheese"; SELECT * FROM Entry WHERE DATE > "2022-10-02";

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE Blog;

USE Blog;

CREATE TABLE Entry {

	Date date,
	Author varchar(50),	
	Title varchar(50),

};

INSERT INTO Entry VALUES(“2022-10-10”, “Sal”, “Cheese Lover”);

INSERT INTO Entry VALUES(“2022-10-11”, “Taylor”,“Parm”);

INSERT INTO Entry VALUES(“2022-10-11”, “Augustine”, “Mozzarella”);

INSERT INTO Entry VALUES(“2022-10-11”, “James”, “I like Cheese”);

UPDATE Entry SET title = “Jaime Fromage” WHERE title = “I like Cheese”

SELECT * FROM Entry WHERE date < “2022-10-02” AND > “2022-10-08”

CREATE DATABASE Blog; USE Blog; CREATE TABLE Entry { Date date, Author varchar(50), Title varchar(50), }; INSERT INTO Entry VALUES(“2022-10-10”, “Sal”, “Cheese Lover”); INSERT INTO Entry VALUES(“2022-10-11”, “Taylor”,“Parm”); INSERT INTO Entry VALUES(“2022-10-11”, “Augustine”, “Mozzarella”); INSERT INTO Entry VALUES(“2022-10-11”, “James”, “I like Cheese”); UPDATE Entry SET title = “Jaime Fromage” WHERE title = “I like Cheese” SELECT * FROM Entry WHERE date < “2022-10-02” AND > “2022-10-08”

-- Oct 5 In-Class Exercise Thread

CREATE DATABASE BLOG;

user BLOG;

CREATE TABLE ENTRY (

   title VARCHAR(35) NOT NULL,
   post TEXT,
   postDate date NOT NULL,

);

INSERT INTO ENTRY VALUES

   ("Cheddar", "Cheddar cheese is okay", 2022-10-5),
   ("I like cheese", "I'm just kidding, not really", 2022-10-6),
   ("Cheese", "Cheese on everything", 2022-10-7);

UPDATE ENTRY SET title='Jaime fromage' WHERE title='I like cheese'; SELECT * FROM ENTRY WHERE date > '2022-09-28';

CREATE DATABASE BLOG; user BLOG; CREATE TABLE ENTRY ( title VARCHAR(35) NOT NULL, post TEXT, postDate date NOT NULL, ); INSERT INTO ENTRY VALUES ("Cheddar", "Cheddar cheese is okay", 2022-10-5), ("I like cheese", "I'm just kidding, not really", 2022-10-6), ("Cheese", "Cheese on everything", 2022-10-7); UPDATE ENTRY SET title='Jaime fromage' WHERE title='I like cheese'; SELECT * FROM ENTRY WHERE date > '2022-09-28';

-- Oct 5 In-Class Exercise Thread

 CREATE database blogdatabase; USE blogdatabase; CREATE table blogEntries (

	blogID int primary key,
	title varchar(60),
	content varchar(300),
        submission_date date

); INSERT INTO blogEntries(blogID, title, content, submission_date) values (1, "Cheese is great", "content", "2022-12-15"); INSERT INTO blogEntries(blogID, title, content, submission_date) values (2, "Cheesy crusts are tasty", "cheese crusts are crusty!", "2022-11-17"); INSERT INTO blogEntries(blogID, title, content, submission_date) values (3, "Cheeky Cheese", "Best cheese slogan", "2022-09-09"); UPDATE blogEntries SET title = "Mozzerella" WHERE title = "Best cheese"; SELECT * FROM blogEntries where submission_date >= "2022-05-19";

CREATE database blogdatabase; USE blogdatabase; CREATE table blogEntries ( blogID int primary key, title varchar(60), content varchar(300), submission_date date ); INSERT INTO blogEntries(blogID, title, content, submission_date) values (1, "Cheese is great", "content", "2022-12-15"); INSERT INTO blogEntries(blogID, title, content, submission_date) values (2, "Cheesy crusts are tasty", "cheese crusts are crusty!", "2022-11-17"); INSERT INTO blogEntries(blogID, title, content, submission_date) values (3, "Cheeky Cheese", "Best cheese slogan", "2022-09-09"); UPDATE blogEntries SET title = "Mozzerella" WHERE title = "Best cheese"; SELECT * FROM blogEntries where submission_date >= "2022-05-19";

-- Oct 5 In-Class Exercise Thread

 CREATE DATABASE BLOG;
 use BLOG;
 CREATE TABLE ENTRY (
    id INT,
    title varchar(50) not null,
    desc varchar(200),
    date Date
 );
 INSERT INTO ENTRY VALUES 
 (1,"Brie", "Not smelly","2022-10-6"),
 (2,"Cheddar", "Not smelly and very. tasty","2022-10-6"),
 (3,"Blue cheese", "Absolutely disgusting","2022-10-5");
 UPDATE ENTRY
 SET title="Jaime fromage"
 WHERE id=2;
 select * from ENTRY where date> "2022-10-5"

(Edited: 2022-10-12)

CREATE DATABASE BLOG; use BLOG; CREATE TABLE ENTRY ( id INT, title varchar(50) not null, desc varchar(200), date Date ); INSERT INTO ENTRY VALUES (1,"Brie", "Not smelly","2022-10-6"), (2,"Cheddar", "Not smelly and very. tasty","2022-10-6"), (3,"Blue cheese", "Absolutely disgusting","2022-10-5"); UPDATE ENTRY SET title="Jaime fromage" WHERE id=2; select * from ENTRY where date> "2022-10-5"