-- Dec 5 In-Class Exercise

CREATE TABLE my_table (a INT, b VARCHAR(20), c CHAR(1)); INSERT INTO my_table values (1, "one", 'a'), (5, "five", 'e'), (6, "six", 's'), (7, "seven", 'i'); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); Output: a:6 b:six c:s a:7 b:seven c:i

-- Dec 5 In-Class Exercise

 rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5");   // perform query
            while (rs.next()) {                  // next() used to get the next row and advance

                int a = rs.getInt("a");
                String b = rs.getString("b");
                String c = rs.getString("c");
                System.out.println("a:" + a + "\tb:" + b + "\tc:" + c);
            }

<u>MYSQL:</u> ALTER TABLE my_table ADD c CHAR(1); INSERT INTO my_table VALUES (25, 'Sam', 'M'), (50, 'Jane', 'F'), (99, 'Bob' , 'M'), (109, 'Kate', 'F'); <u>Java:</u> rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); // perform query while (rs.next()) { // next() used to get the next row and advance int a = rs.getInt("a"); String b = rs.getString("b"); String c = rs.getString("c"); System.out.println("a:" + a + "\tb:" + b + "\tc:" + c); } <u>Output:</u> a:25 b:Sam c:M a:50 b:Jane c:F a:99 b:Bob c:M a:109 b:Kate c:F

-- Dec 5 In-Class Exercise

ALTER TABLE my_table ADD c CHAR(1); INSERT INTO my_table values (2, "two", 'a'), (4, "four", 'e'), (23, "twentythree", 's'), (7, "seven", 'i'); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); Output: a: 23 b:twentythree Output a:7 b:seven

-- Dec 5 In-Class Exercise

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

Ryan Moore CREATE TABLE my_table ( a INT, b VARCHAR(20), c CHAR(1) ); INSERT INTO my_table VALUES (1, "hi", "a"), (2, "bye", "b"), (3, "yo", "c"), (4, "ay", "d"); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5");

-- Dec 5 In-Class Exercise

<nowiki> CREATE TABLE my_table (a INT, b VARCHAR(20), c CHAR(1)); INSERT INTO my_table VALUES (1, "one", "a"), (6, "six", "f"), (3, "three", "c"), (7, "seven", "g"); rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); Output: a:6 b:six c:f a:7 b:seven c:g </nowiki>

-- Dec 5 In-Class Exercise

ALTER TABLE my_table ADD COLUMN c CHAR(1) AFTER b; <br> INSERT INTO my_table VALUES (4, “Mary”, “A”), (5, “had”, “B”), (6, “a”, “C”), (7, “little”, “D”), (8, “lamb”, “E”);<br> a:6 b:a c:C <br> a:7 b:little c:D <br> a:8 b:lamb c:E <br>

-- Dec 5 In-Class Exercise

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

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

-- Dec 5 In-Class Exercise

 ALTER TABLE my_table
 ADD a INT,
 ADD b VARCHAR(20),
 ADD c CHAR(1);
 
 INSERT INTO my_table VALUES(1,'elf','a'),(2,'troll','b'),(3,'human','c'),(4,'animal','d');

 rs = smtm.executeQuery("SELECT * FROM my_table WHERE a>5");
 output:

ALTER TABLE my_table ADD a INT, ADD b VARCHAR(20), ADD c CHAR(1); INSERT INTO my_table VALUES(1,'elf','a'),(2,'troll','b'),(3,'human','c'),(4,'animal','d'); rs = smtm.executeQuery("SELECT * FROM my_table WHERE a>5"); output:

-- Dec 5 In-Class Exercise

CREATE TABLE my_table (a INT, b VARCHAR(20), c CHAR(1)); <br> INSERT INTO my_table VALUES (3, "zz", 'a'), (4, "aa", 'b'), (5, "ww", 'c'), (6, "qq", 'd');<br> rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5");<br> Output: <br> a:6 b:qq c:d

-- Dec 5 In-Class Exercise

CREATE TABLE my_table (a int, b varchar(20), c char(1)); <br> INSERT INTO my_table (6, "hello", 'a'), (5, "world", 'b'), (4, "happy", 'c'), (3, "holidays", 'd'); <br> rs = stmt.executeQuery("SELECT * FROM my_table WHERE a > 5"); <br> <br> output: a:6 b:hello c:a