Script started on Thu 14 Jan 2021 05:26:15 PM AST
]0;ishoebot@id414m12:~[ishoebot@id414m12 ~]$ mysql -h cs1103.cs.unb.ca -u <enter username> -pname> -p -p[K -p[K -p[K -p[K -p[K -p[K -p[K -p[K -p[K-p[K -p[K -p[K -p[K -p[K -p[K -p[Ki -ps -ph -po -pe -pb -po -pt -p

Enter password: 
(B[0;1mWelcome to the MariaDB monitor.  Commands end with ; or \g.
(B[m(B[0;1mYour MariaDB connection id is 12752
Server version: 5.5.65-MariaDB MariaDB Server

(B[m(B[0;1mCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

(B[m(B[0;1mType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

(B[m[?1034hMariaDB [(none)]> show ta[K[Kdatabases
    -> ;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| Ch01_Problems        |
| Ch01_Text            |
| Ch02_DealCo          |
| Ch02_InsureCo        |
| Ch02_SaleCo          |
| Ch02_TinyCollege     |
| Ch03_AviaCo          |
| Ch03_BeneCo          |
| Ch03_CheapCo         |
| Ch03_CollegeQue      |
| Ch03_CollegeTry      |
| Ch03_CollegeTry2     |
| Ch03_InsureCo        |
| Ch03_Museum          |
| Ch03_NoComp          |
| Ch03_Relational_DB   |
| Ch03_SaleCo          |
| Ch03_StoreCo         |
| Ch03_Theatre         |
| Ch03_TinyCollege     |
| Ch03_TransCo         |
| Ch03_VendingCo       |
| Ch04_Clinic          |
| Ch04_CollegeTry      |
| Ch04_PartCo          |
| Ch04_ShortCo         |
| Ch04_TinyCollege     |
| Ch04_TinyCollege_Alt |
| Ch07_ConstructCo     |
| Ch07_Fact            |
| Ch07_LargeCo         |
| Ch07_SaleCo          |
| ishoebot             |
+----------------------+
(B[0;1m34 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [(none)]> s[Kuse Ch01_Text
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

(B[0;1mDatabase changed
(B[mMariaDB [Ch01_Text]> show columns from [K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[K[Kshow tables;
+---------------------+
| Tables_in_Ch01_Text |
+---------------------+
| AGENT               |
| CERTIFIED           |
| CUSTOMER            |
| EMPLOYEE            |
| EMPLOYEESKILLS      |
| SKILL               |
+---------------------+
(B[0;1m6 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> show columnds from[K[K[K[K[K[K[K[K[K[K[Klom[Kum[K[K[Kumns from AGENT
    -> ;
+-----------+---------------+------+-----+---------+-------+
| Field     | Type          | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+-------+
| A_NAME    | varchar(15)   | YES  |     | NULL    |       |
| A_PHONE   | varchar(12)   | YES  |     | NULL    |       |
| A_ADDRESS | varchar(20)   | YES  |     | NULL    |       |
| ZIP       | varchar(5)    | YES  |     | NULL    |       |
| HIRED     | datetime      | YES  |     | NULL    |       |
| YTD_PAY   | decimal(10,2) | YES  |     | NULL    |       |
| YTD_FIT   | decimal(10,2) | YES  |     | NULL    |       |
| YTD_FICA  | decimal(10,2) | YES  |     | NULL    |       |
| YTD_SLS   | decimal(10,2) | YES  |     | NULL    |       |
| DEP       | int(11)       | YES  |     | NULL    |       |
+-----------+---------------+------+-----+---------+-------+
(B[0;1m10 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> select * from AGENT
    -> ;
+--------------+--------------+--------------------+-------+---------------------+----------+---------+----------+-----------+------+
| A_NAME       | A_PHONE      | A_ADDRESS          | ZIP   | HIRED               | YTD_PAY  | YTD_FIT | YTD_FICA | YTD_SLS   | DEP  |
+--------------+--------------+--------------------+-------+---------------------+----------+---------+----------+-----------+------+
| Alex B. Alby | 713-228-1249 | 123 Toll, Nash, TN | 37119 | 2002-11-01 00:00:00 | 26566.24 | 6641.56 |  2125.30 | 132735.75 |    3 |
| Leah F. Hahn | 615-882-1244 | 334 Main, Fox, KY  | 25246 | 1988-05-23 00:00:00 | 32213.76 | 8053.44 |  2577.10 | 138967.35 |    0 |
| John T. Okon | 615-123-5589 | 452 Elm, New, TN   | 36155 | 2007-06-15 00:00:00 | 23198.29 | 5799.57 |  1855.86 | 127093.45 |    2 |
+--------------+--------------+--------------------+-------+---------------------+----------+---------+----------+-----------+------+
(B[0;1m3 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> show columnds from EMPLOYEE
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'columnds from EMPLOYEE' at line 1
(B[0;7m(B[mMariaDB [Ch01_Text]> ;show columnds from EMPLOYEE
[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C[C;[Kshow columnds from EMPLOYEE[1P[1P[1@s
    -> ;
+-------------------+-------------+------+-----+---------+-------+
| Field             | Type        | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| EMPLOYEE_ID       | varchar(6)  | NO   | PRI | NULL    |       |
| EMPLOYEE_FNAME    | varchar(20) | YES  |     | NULL    |       |
| EMPLOYEE_LNAME    | varchar(20) | YES  |     | NULL    |       |
| EMPLOYEE_HIREDATE | datetime    | YES  |     | NULL    |       |
| EMPLOYEE_TITLE    | varchar(30) | YES  |     | NULL    |       |
+-------------------+-------------+------+-----+---------+-------+
(B[0;1m5 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> select * from EMPLOYEE
    -> ;
+-------------+----------------+----------------+---------------------+---------------------+
| EMPLOYEE_ID | EMPLOYEE_FNAME | EMPLOYEE_LNAME | EMPLOYEE_HIREDATE   | EMPLOYEE_TITLE      |
+-------------+----------------+----------------+---------------------+---------------------+
| 02345       | Johnny         | Jones          | 1997-02-14 00:00:00 | DBA                 |
| 03373       | Franklin       | Johnson        | 2004-03-15 00:00:00 | Purchasing Agent    |
| 04893       | Patricia       | Richards       | 2006-06-11 00:00:00 | DBA                 |
| 06234       | Jasmine        | Patel          | 2007-08-10 00:00:00 | Programmer          |
| 08273       | Marco          | Bienz          | 2008-07-28 00:00:00 | Analyst             |
| 09002       | Ben            | Joiner         | 2012-05-20 00:00:00 | Clerk               |
| 09283       | Juan           | Chavez         | 2012-07-04 00:00:00 | Clerk               |
| 09382       | Jessica        | Johnson        | 2012-08-02 00:00:00 | Database Programmer |
| 10282       | Amanda         | Richardson     | 2013-04-11 00:00:00 | Clerk               |
| 13383       | Raymond        | Matthews       | 2014-03-12 00:00:00 | Programmer          |
| 13567       | Robert         | Almond         | 2014-09-30 00:00:00 | Analyst             |
| 13932       | Megan          | Lee            | 2015-09-29 00:00:00 | Programmer          |
| 14311       | Lee            | Duong          | 2014-09-01 00:00:00 | Programmer          |
+-------------+----------------+----------------+---------------------+---------------------+
(B[0;1m13 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> select EMPLOYEE_ID [K, EMPLOYEE_TITLE from EMPLOYEE
    -> ;
+-------------+---------------------+
| EMPLOYEE_ID | EMPLOYEE_TITLE      |
+-------------+---------------------+
| 02345       | DBA                 |
| 03373       | Purchasing Agent    |
| 04893       | DBA                 |
| 06234       | Programmer          |
| 08273       | Analyst             |
| 09002       | Clerk               |
| 09283       | Clerk               |
| 09382       | Database Programmer |
| 10282       | Clerk               |
| 13383       | Programmer          |
| 13567       | Analyst             |
| 13932       | Programmer          |
| 14311       | Programmer          |
+-------------+---------------------+
(B[0;1m13 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> show col[K[K[K[K[K[K[Khow columns from EMPLOYEE
    -> ;
+-------------------+-------------+------+-----+---------+-------+
| Field             | Type        | Null | Key | Default | Extra |
+-------------------+-------------+------+-----+---------+-------+
| EMPLOYEE_ID       | varchar(6)  | NO   | PRI | NULL    |       |
| EMPLOYEE_FNAME    | varchar(20) | YES  |     | NULL    |       |
| EMPLOYEE_LNAME    | varchar(20) | YES  |     | NULL    |       |
| EMPLOYEE_HIREDATE | datetime    | YES  |     | NULL    |       |
| EMPLOYEE_TITLE    | varchar(30) | YES  |     | NULL    |       |
+-------------------+-------------+------+-----+---------+-------+
(B[0;1m5 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> list cus[K[K[KCu[K[K[K[K[K[K[Kshow tables
    -> ;
+---------------------+
| Tables_in_Ch01_Text |
+---------------------+
| AGENT               |
| CERTIFIED           |
| CUSTOMER            |
| EMPLOYEE            |
| EMPLOYEESKILLS      |
| SKILL               |
+---------------------+
(B[0;1m6 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> show columnds from CUSTOMER
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'columnds from CUSTOMER' at line 1
(B[0;7m(B[mMariaDB [Ch01_Text]> ;show columnds from CUSTOMER[C[C[1P[1P[1@s
    -> ;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| C_NAME    | varchar(20)  | YES  |     | NULL    |       |
| C_PHONE   | varchar(12)  | YES  |     | NULL    |       |
| C_ADDRESS | varchar(30)  | YES  |     | NULL    |       |
| C_ZIP     | varchar(5)   | YES  |     | NULL    |       |
| A_NAME    | varchar(20)  | YES  |     | NULL    |       |
| A_PHONE   | varchar(12)  | YES  |     | NULL    |       |
| TP        | varchar(2)   | YES  |     | NULL    |       |
| AMT       | decimal(6,2) | YES  |     | NULL    |       |
| REN       | datetime     | YES  |     | NULL    |       |
+-----------+--------------+------+-----+---------+-------+
(B[0;1m9 rows in set (0.01 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> list C_NAME [K, C_P[KADDRESS [K, C_PHONE from CUSTOMER;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'list C_NAME, C_ADDRESS, C_PHONE from CUSTOMER' at line 1
(B[0;7m(B[mMariaDB [Ch01_Text]> list C_NAME, C_ADDRESS, C_PHONE from CUSTOMER;[C[C[C[C[1P[1P[1P[1P[1@s[1@e[1@l[1@e[1@c[1@t
+-----------------+------------------------+--------------+
| C_NAME          | C_ADDRESS              | C_PHONE      |
+-----------------+------------------------+--------------+
| Alfred A. Ramas | 218 Fork Rd., Babs, TN | 615-844-2573 |
| Leona K. Dunne  | Box 12A, Fox, KY       | 713-894-1238 |
| Kathy W. Smith  | 125 Oak Ln, Babs, TN   | 615-894-2285 |
| Paul F. Olowski | 217 Lee Ln., Babs, TN  | 615-894-2180 |
| Myron Orlando   | Box 111, New, TN       | 615-222-1672 |
| Amy B. O'Brian  | 387 Troll Dr., Fox, KY | 713-442-3381 |
| James G. Brown  | 21 Tye Rd., Nash, TN   | 615-297-1228 |
| George Williams | 155 Maple, Nash, TN    | 615-290-2556 |
| Anne G. Farriss | 2119 Elm, Crew, KY     | 713-382-7185 |
| Olette K. Smith | 2782 Main, Nash, TN    | 615-297-3809 |
+-----------------+------------------------+--------------+
(B[0;1m10 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> exit
(B[0;1mBye
(B[m]0;ishoebot@id414m12:~[ishoebot@id414m12 ~]$ exit

exit

Script done on Thu 14 Jan 2021 05:33:52 PM AST
