Yioop - PHP Search Engine

-- Dec 5 In-Class Exercise

CREATE TABLE my_table (a int, b varchar(20), c char(1)); INSERT INTO my_table (6, "SJSU", 'a'), (7, "CSU", 'b'), (4, "EVC", 'c'), (3, "DeAnza", 'd'); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5");

Output: a:6 b:SJSU c:a a:7 b:CSU c:b

CREATE TABLE my_table (a int, b varchar(20), c char(1)); INSERT INTO my_table (6, "SJSU", 'a'), (7, "CSU", 'b'), (4, "EVC", 'c'), (3, "DeAnza", 'd'); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); Output: a:6 b:SJSU c:a a:7 b:CSU c:b

-- Dec 5 In-Class Exercise

CREATE TABLE test (a INT, b VARCHAR(20), c CHAR(1));

 INSERT INTO test VALUES (6, “abc”, “A”), (8, “cad”, “B”), (4, “dea”, “C”), (3, “leo”, “C”);
 
 rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5");

 Output:
 a:6	b:abc
 a:8	b:cad

CREATE TABLE test (a INT, b VARCHAR(20), c CHAR(1)); INSERT INTO test VALUES (6, “abc”, “A”), (8, “cad”, “B”), (4, “dea”, “C”), (3, “leo”, “C”); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); Output: a:6 b:abc a:8 b:cad

-- Dec 5 In-Class Exercise

 CREATE TABLE my_table (
      a INT,
      b VARCHAR(5),
      c CHAR(1)
   );
   INSERT INTO my_table VALUES
   (1, "hello", 'H'), (1, "bye", 'B'), (3, "hey", 'Y'), (4, "oh", 'O');

 Output   
   a:3	b:hey	c:Y
   a:4	b:Oh	c:O

CREATE TABLE my_table ( a INT, b VARCHAR(5), c CHAR(1) ); INSERT INTO my_table VALUES (1, "hello", 'H'), (1, "bye", 'B'), (3, "hey", 'Y'), (4, "oh", 'O'); Output a:3 b:hey c:Y a:4 b:Oh c:O

-- Dec 5 In-Class Exercise

CREATE TABLE my_table (

   a INT,
   b VARCHAR(20),
   c CHAR(1)

);

INSERT INTO my_table VALUES (1,”hello”,‘a’), (2,”world”,’b’), (3,”hi”,’c’), (4,”HEY,’d’), (5,"BYE",'e');

rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 3");

Output:

a:4 b:HEY c:d

a:5 b:BYE c:e

(Edited: 2018-12-10)

CREATE TABLE my_table ( a INT, b VARCHAR(20), c CHAR(1) ); INSERT INTO my_table VALUES (1,”hello”,‘a’), (2,”world”,’b’), (3,”hi”,’c’), (4,”HEY,’d’), (5,"BYE",'e'); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 3"); Output: a:4 b:HEY c:d a:5 b:BYE c:e

-- Dec 5 In-Class Exercise

CREATE TABLE my_table (a INT, b VARCHAR(20), c CHAR(1));

 
 INSERT INTO my_table VALUES (2, "aaaa", "b"), (6, "bbbb", "c"), (8, "aabb", "d"), (10, "Hello", "e");
 Output:

 a:6	b:bbbb	c:c

 a:8	b:aabb	c:d

 a:10	b:Hello	c:e

(Edited: 2018-12-10)

CREATE TABLE my_table (a INT, b VARCHAR(20), c CHAR(1)); INSERT INTO my_table VALUES (2, "aaaa", "b"), (6, "bbbb", "c"), (8, "aabb", "d"), (10, "Hello", "e"); Output: a:6 b:bbbb c:c a:8 b:aabb c:d a:10 b:Hello c:e