Yioop - PHP Search Engine

-- Nov 28 In-Class Exercise

 create table R(
   ...> A int, B int default 1)
   ...> ;
 insert into R (A) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
 insert into R(A,B) select A,A*A as B from R;
 delete from R where B<25;
 update R set B=26 where B=25;

create table R( ...> A int, B int default 1) ...> ; insert into R (A) values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); insert into R(A,B) select A,A*A as B from R; delete from R where B<25; update R set B=26 where B=25;

-- Nov 28 In-Class Exercise

C:\Users\David>sqlite3 foo SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints.
sqlite> CREATE TABLE R(A INT, B INT DEFAULT 1);
sqlite> INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
sqlite> INSERT INTO R(A, B) SELECT A, A * A AS B FROM R;
sqlite> DELETE FROM R WHERE B < 25;
sqlite> UPDATE R SET B = 26 WHERE B = 25;

C:\Users\David>sqlite3 foo SQLite version 3.24.0 2018-06-04 19:24:41 Enter ".help" for usage hints. sqlite> CREATE TABLE R(A INT, B INT DEFAULT 1); sqlite> INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); sqlite> INSERT INTO R(A, B) SELECT A, A * A AS B FROM R; sqlite> DELETE FROM R WHERE B < 25; sqlite> UPDATE R SET B = 26 WHERE B = 25;

-- Nov 28 In-Class Exercise

CREATE TABLE R(A INT, B INT DEAFULT 1); INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); INSERT INTO R(A, B) SELECT A, A*A FROM R; DELETE FROM R WHERE B < 25; UPDATE R SET B = 26 WHERE B = 25;

-- Nov 28 In-Class Exercise

 CREATE TABLE R(A INT, B INT DEFAULT 1);

 INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

 INSERT INTO R VALUES(SELECT A, A*A AS B) FROM R;

 DELETE FROM R WHERE B < 25;

 UPDATE R SET B = 26 WHERE B = 25;

CREATE TABLE R(A INT, B INT DEFAULT 1); INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); INSERT INTO R VALUES(SELECT A, A*A AS B) FROM R; DELETE FROM R WHERE B < 25; UPDATE R SET B = 26 WHERE B = 25;

-- Nov 28 In-Class Exercise

CREATE TABLE R(A INT, B INT DEFAULT 1);
INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
INSERT INTO R(A, B) SELECT A, A*A FROM R;
DELETE FROM R WHERE B < 25;
UPDATE R SET B = 26 WHERE B = 25;

CREATE TABLE R(A INT, B INT DEFAULT 1); INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); INSERT INTO R(A, B) SELECT A, A*A FROM R; DELETE FROM R WHERE B < 25; UPDATE R SET B = 26 WHERE B = 25;

-- Nov 28 In-Class Exercise

CREATE TABLE R( A INT, B INT DEFAULT 1);

INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

INSERT INTO R(A,B) SELECT A, A*A AS B FROM R

DELETE FROM R WHERE B<25;

UPDATE R SET B=26 WHERE B=25;

CREATE TABLE R( A INT, B INT DEFAULT 1); INSERT INTO R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10); INSERT INTO R(A,B) SELECT A, A*A AS B FROM R DELETE FROM R WHERE B<25; UPDATE R SET B=26 WHERE B=25;

-- Nov 28 In-Class Exercise

CREATE TABLE R(

	A INT, 
	B INT DEFAULT 1
   )
   INSERT INTO R(A) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); 
   UPDATE R
   SET B = A*A;
   DELETE FROM A
   WHERE B < 25;
   UPDATE R
   SET B = 26
   WHERE B = 25;

CREATE TABLE R( A INT, B INT DEFAULT 1 ) INSERT INTO R(A) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); UPDATE R SET B = A*A; DELETE FROM A WHERE B < 25; UPDATE R SET B = 26 WHERE B = 25;