Script started on Thu 14 Jan 2021 05:08:01 PM AST
]0;ishoebot@id414m35:~[ishoebot@id414m35 ~]$ exitls[Kexit[Kexitls[Kexit[Kmysql -h cs1103.cs.unb.ca -u <enter username> -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 12655
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)]> 5show [K[K[K[K[K[Kshow databax[Kses
    -> ;
+----------------------+
| 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.01 sec)
(B[m(B[0;1m
(B[mMariaDB [(none)]> use Ch01_Text
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 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 columns from AGENT
    -> ;
+-----------+---------------+------+-----+---------+-------+
| 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]> ;show columns from AGENT[K[K[K[K[KEMPL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]> select EMPLOYEE_ID [K, EMPLOYEE_Ti[KITLE 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[m    -> ;.[K
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 '.' at line 1
(B[0;7m(B[mMariaDB [Ch01_Text]> ;.select EMPLOYEE_ID, EMPLOYEE_TITLE from EMPLOYEE;
+-------------+---------------------+
| 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 columns 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]> S[Kselect A_NAME [K, A-[K_P[KAd[KDDRESS [K, A_e[KPh[KHONE from AG
AGAINST          AGENT            AGENT.A_ADDRESS  AGENT.A_NAME     AGENT.A_PHONE    AGENT.DEP        AGENT.HIRED      AGENT.YTD_FICA   AGENT.YTD_FIT    AGENT.YTD_PAY    AGENT.YTD_SLS    AGENT.ZIP        AGGREGATE        
MariaDB [Ch01_Text]> select A_NAME, A_ADDRESS, A_PHONE from AGENT
    -> ;
+--------------+--------------------+--------------+
| A_NAME       | A_ADDRESS          | A_PHONE      |
+--------------+--------------------+--------------+
| Alex B. Alby | 123 Toll, Nash, TN | 713-228-1249 |
| Leah F. Hahn | 334 Main, Fox, KY  | 615-882-1244 |
| John T. Okon | 452 Elm, New, TN   | 615-123-5589 |
+--------------+--------------------+--------------+
(B[0;1m3 rows in set (0.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> 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 columns from CUSTOMER
    -> ;
+-----------+--------------+------+-----+---------+-------+
| 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.00 sec)
(B[m(B[0;1m
(B[mMariaDB [Ch01_Text]> select A[KC_NAME [K, C-[K_Ad[KDDRESS [K, C_Po[Kh[KHONE from cus[K[K[KCUs[KSTOMER
    -> ;
+-----------------+------------------------+--------------+
| 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@id414m35:~[ishoebot@id414m35 ~]$ exit

exit

Script done on Thu 14 Jan 2021 05:18:31 PM AST
