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 SELECT A, A*A AS B FROM R;

 > DELETE FROM R WHERE B <25;

 > UPDATE R SET B = 26 WHERE B =25;

(Edited: 2018-11-28)

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

 INSERT INTO R 
   SELECT A, A * A AS B 
   FROM R;

 DELETE FROM R 
 WHERE B < 25;

 UPDATE R 
 SET B = 26 
 WHERE B = 25;

(Edited: 2018-11-29)

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 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 
   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 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 INTEGER, B INTEGER 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;

(Edited: 2018-11-30)

CREATE TABLE R(A INTEGER, B INTEGER 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;

(Edited: 2018-12-01)

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

(Edited: 2018-12-02)

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;

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

-- Nov 28 In-Class Exercise

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