snick@Vaxis:~$ ssh artemis
Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Mon Nov 4 13:27:33 2024 from 136.168.38.41
nick@artemis:~$ mysql companyf24
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
BWelcome to the MariaDB monitor. Commands end with ; or \g.
BBYour MariaDB connection id is 87983
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10
BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
BMariaDB [companyf24]> DELIMITER //
MariaDB [companyf24]>
MariaDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
-> BEFORE UPDATE ON Employee
-> FOR EACH ROW
-> IF OLD.Salary > NEW.Salary THEN
-> UPDATE Employee
-> SET Salary = OLD.Salary
-> WHERE SSN = OLD.SSN;
-> END IF//
BQuery OK, 0 rows affected (0.008 sec)
BB
BMariaDB [companyf24]>
MariaDB [companyf24]> DELIMITER ;
MariaDB [companyf24]> show triggers;
+-----------------------------+--------+----------+-----------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+-----------------------------+--------+----------+-----------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+
| onemployeeupdate | UPDATE | Employee | IF OLD.Dnumber <> NEW.Dnumber THEN
INSERT INTO EmployeeHistory (SSN, Dnumber) VALUES (OLD.SSN, OLD.Dnumber);
END IF | BEFORE | 2024-10-21 13:57:06.49 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | nick@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci |
| EmployeeSalaryUpdateTrigger | UPDATE | Employee | IF OLD.Salary > NEW.Salary THEN
UPDATE Employee
SET Salary = OLD.Salary
WHERE SSN = OLD.SSN;
END IF | BEFORE | 2024-11-06 13:20:46.17 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | nick@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci |
+-----------------------------+--------+----------+-----------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+
B2 rows in set (0.002 sec)
BB
BMariaDB [companyf24]> select * from Employee order by rand();
+-------------+---------+-------------+-------+----------------+-------------+--------------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-------------+-------+----------------+-------------+--------------------------+--------+---------------+
| 752-84-8775 | 8 | Laurens | M | Cotte | 1973-09-24 | 3 Miller Avenue | 59005 | 658-05-4163 |
| 607-74-1169 | 9 | Gertruda | C | Gockelen | 1976-03-07 | 79091 Menomonie Alley | 158057 | 717-17-8602 |
| 790-22-4853 | 7 | Morgen | L | Harbor | 1994-01-18 | 042 Sunbrook Alley | 240027 | 472-81-9344 |
| 504-74-1709 | 5 | Nickola | R | Andric | 1984-07-10 | 94786 Village Way | 69938 | 160-02-1988 |
| 858-82-4762 | 8 | Cornela | D | Kildahl | 1976-07-27 | 632 7th Way | 176012 | 384-60-5206 |
| 296-88-3962 | 9 | Timothee | T | Otteridge | 1991-09-10 | 353 Wayridge Way | 200554 | 711-47-5728 |
| 479-65-6252 | 1 | Wiatt | M | Tunno | 1990-08-20 | 51 Cherokee Crossing | 223879 | 260-53-9920 |
| 253-37-4748 | 3 | Mollie | J | Valentin | 1954-05-24 | 9 Northridge Avenue | 153802 | 152-34-5278 |
| 179-46-3342 | 4 | Bartholomeo | C | Dulanty | 2003-04-21 | 797 Florence Hill | 102293 | 771-03-0333 |
| 240-65-0520 | 2 | Hailey | K | Tickel | 1983-05-06 | 1 Texas Park | 102606 | 257-13-3187 |
| 198-51-1274 | 6 | Agnes | M | Pagram | 1958-07-01 | 27 Goodland Lane | 37679 | 556-94-7372 |
| 898-36-7152 | 3 | Ranna | N | Tobin | 1951-10-15 | 176 Village Alley | 184976 | 738-51-8411 |
| 884-82-2308 | 3 | Joceline | G | Baxill | 1962-06-23 | 48 Hauk Trail | 117731 | 784-07-2436 |
| 444-10-9453 | 2 | Ernestus | S | Gleaves | 1983-05-16 | 4 Susan Drive | 58762 | 274-15-6294 |
| 884-44-5249 | 3 | Sean | A | Morriarty | 1956-12-21 | 14860 Hauk Junction | 209607 | 412-70-8841 |
| 456-07-1401 | 7 | Benito | B | Assiratti | 2002-03-16 | 31060 Orin Avenue | 111130 | 374-36-0897 |
| 174-19-9377 | 10 | Jarrad | S | McCullogh | 2001-09-23 | 88 Merry Terrace | 124273 | 140-38-1442 |
| 708-11-0063 | 5 | Eimile | A | Filyashin | 1971-06-18 | 27 Farmco Point | 219409 | 501-31-5094 |
| 649-94-7049 | 7 | Minta | N | Bradforth | 1953-10-26 | 535 Surrey Parkway | 234085 | 138-18-7914 |
| 686-50-9129 | 1 | Abrahan | L | Ratnege | 1996-06-28 | 18 Forest Run Parkway | 44912 | 142-37-2034 |
| 488-58-0256 | 7 | Cooper | G | Hawford | 1951-11-07 | 3543 Larry Pass | 162242 | 792-36-3050 |
| 234-13-0235 | 9 | Kali | K | Smithers | 1998-06-07 | 22 Calypso Center | 53815 | 651-22-3782 |
| 600-30-0783 | 3 | Mathe | N | Barttrum | 1953-03-13 | 7 Russell Lane | 200440 | 751-62-8627 |
| 429-10-4540 | 1 | Hertha | G | Meads | 1983-07-11 | 5398 Longview Park | 240370 | 408-65-8026 |
| 872-67-7877 | 2 | Lily | C | Clubbe | 1995-08-19 | 2 Schurz Parkway | 217243 | 199-78-3996 |
| 571-69-4266 | 7 | Clo | C | Waszczykowski | 1993-06-25 | 9870 Scott Center | 65294 | 151-21-5386 |
| 342-19-0997 | 4 | Lyda | M | Learoyde | 1962-10-14 | 0365 Jackson Court | 130202 | 641-81-3222 |
| 489-78-5381 | 3 | Jerrylee | D | Salliere | 2002-10-24 | 5 Del Sol Avenue | 197266 | 137-87-4928 |
| 158-44-5836 | 5 | Lauretta | C | Lars | 1976-07-22 | 78 Fair Oaks Terrace | 67137 | 167-27-4761 |
| 648-14-2718 | 3 | Gloriana | K | Tildesley | 1974-04-20 | 50384 Oakridge Park | 158296 | 311-64-9456 |
| 515-77-3666 | 10 | Selma | D | Duly | 1976-02-19 | 9 Southridge Center | 102921 | 850-66-9042 |
| 511-73-5142 | 1 | Janka | R | Hitchens | 1993-01-07 | 223 Macpherson Place | 189433 | 557-14-8462 |
| 753-93-1975 | 2 | Shel | A | McQuillin | 1976-01-31 | 34 Starling Plaza | 34472 | 768-75-2105 |
| 103-43-6534 | 10 | Kippar | N | Ommanney | 1966-04-09 | 32 Lighthouse Bay Way | 228764 | 782-72-3994 |
| 192-65-9793 | 9 | Taffy | W | Sennett | 1978-08-15 | 0277 Kipling Street | 136542 | 461-62-7430 |
| 232-73-2252 | 2 | Joline | C | Teanby | 1953-12-09 | 2699 Vermont Pass | 77528 | 390-11-4874 |
| 184-41-4519 | 9 | Berenice | V | Di Dello | 1994-11-22 | 15 Elka Parkway | 112460 | 293-97-5018 |
| 201-98-8291 | 3 | Harman | N | Barrows | 1955-03-09 | 04207 American Ash Alley | 220885 | 717-69-4965 |
| 700-84-6055 | 4 | Genna | H | Eunson | 1993-04-05 | 05919 Golf View Terrace | 188564 | 113-64-7826 |
| 615-41-3638 | 4 | Lily | A | Wildash | 1950-09-06 | 19 Graedel Park | 63478 | 205-81-9032 |
| 722-47-2860 | 3 | Dillon | R | Salvadori | 1989-09-23 | 866 Warbler Court | 218669 | 413-39-0863 |
| 160-21-7388 | 8 | Mercy | B | Bryant | 1969-09-05 | 3 Shoshone Hill | 179772 | 231-18-6332 |
| 723-88-6191 | 6 | Carlin | K | Rickesies | 1976-02-26 | 694 Tomscot Pass | 198116 | 461-47-9056 |
| 454-98-3444 | 7 | Lukas | M | MacDirmid | 1994-05-28 | 646 International Circle | 235065 | 269-10-4989 |
| 687-45-8914 | 6 | Egor | P | Osinin | 1988-11-01 | 327 Kingsford Circle | 111854 | 167-34-9728 |
| 592-42-2417 | 9 | Gibby | S | Beldam | 1990-08-30 | 6 Veith Hill | 34221 | 265-64-9915 |
| 772-66-3995 | 9 | Gray | L | Turone | 1984-10-29 | 0 Haas Park | 67690 | 744-95-2396 |
| 221-70-0150 | 8 | Kellie | D | Alexsandrovich | 1972-01-15 | 02 Aberg Hill | 108900 | 349-14-1435 |
| 758-19-5868 | 6 | Emilee | M | Syms | 1970-10-10 | 412 Vernon Drive | 203863 | 757-98-9036 |
| 306-92-5183 | 8 | Silvana | I | Awde | 1963-09-06 | 2 Burrows Drive | 237513 | 849-63-2877 |
| 288-12-9917 | 9 | Norbert | C | Scarce | 1968-03-16 | 98057 Northridge Alley | 230722 | 856-12-7860 |
| 401-65-8167 | 9 | Levy | C | Knolles-Green | 1963-04-16 | 61 Mayer Drive | 148960 | 876-77-3630 |
| 689-31-8418 | 6 | Shea | L | Aitchison | 1955-12-27 | 36641 Russell Circle | 183578 | 556-22-2198 |
| 432-99-2689 | 9 | Sybille | Z | Crommett | 1952-05-16 | 56264 Grasskamp Parkway | 55895 | 726-81-4206 |
| 312-47-3348 | 5 | Cybil | K | Broadwood | 1980-12-09 | 7219 Reindahl Terrace | 143198 | 482-80-6452 |
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36632 | 249-29-3206 |
| 856-81-4983 | 6 | Jarvis | E | Clampton | 1982-08-03 | 4497 Elgar Lane | 205051 | 161-34-3372 |
| 469-87-9831 | 6 | Dniren | D | Gaynesford | 1991-02-18 | 91245 Sheridan Terrace | 85610 | 797-90-0158 |
| 405-04-1356 | 10 | Hammad | D | Ferrolli | 1957-08-31 | 17 Quincy Court | 74878 | 555-36-9606 |
| 749-74-3457 | 7 | Claiborn | G | Jaggli | 1993-03-16 | 10 Rusk Lane | 205122 | 104-32-3426 |
| 197-64-9509 | 9 | Sloan | Y | Hatje | 1964-10-18 | 165 Springview Parkway | 45960 | 730-43-0531 |
| 461-03-9851 | 10 | Orrin | V | O'Gormally | 1966-07-15 | 3 Farragut Pass | 47258 | 558-69-9395 |
| 819-87-3158 | 10 | Joy | V | Mattiazzi | 1952-09-29 | 3 Corry Park | 228458 | 291-38-7811 |
| 103-40-8183 | 7 | Janie | N | Brydell | 1967-06-01 | 835 Corben Parkway | 164337 | 375-65-5664 |
| 140-34-0908 | 3 | Tabby | P | Iveans | 1996-09-27 | 41 Beilfuss Park | 124336 | 628-77-9563 |
| 342-24-8788 | 6 | Marie-ann | S | Mecco | 1950-08-23 | 47887 Pearson Drive | 190910 | 877-83-0052 |
| 868-66-3401 | 7 | Siffre | A | Moffat | 1977-02-09 | 8 Manufacturers Road | 54642 | 140-25-1949 |
| 785-75-7978 | 2 | Noelyn | R | Janeczek | 1968-11-16 | 37446 Mandrake Hill | 192852 | 827-56-3174 |
| 636-12-5374 | 4 | Damon | K | Rawlyns | 1981-04-08 | 55 Village Green Court | 153178 | 851-47-2030 |
| 598-05-9422 | 5 | Madelaine | A | Plowell | 1952-09-10 | 2 Manufacturers Road | 71445 | 854-35-5680 |
| 176-57-7749 | 3 | Jane | M | O' Hogan | 1960-03-22 | 4158 Schmedeman Hill | 101593 | 111-45-2255 |
| 199-51-5758 | 1 | Omar | B | Quince | 1998-02-07 | 41 Summer Ridge Road | 207841 | 801-72-0598 |
| 793-24-8756 | 10 | Hilde | D | Flook | 1956-03-04 | 839 Lawn Park | 167156 | 731-06-2333 |
| 476-04-9905 | 1 | Hasheem | M | Kitchen | 1992-12-27 | 6 Sutherland Terrace | 67106 | 172-09-5735 |
| 618-35-0602 | 10 | Durand | L | Gori | 1986-12-29 | 2274 Vernon Plaza | 33041 | 869-58-2221 |
| 489-29-5492 | 2 | Ward | J | Edgson | 1987-12-07 | 4956 School Pass | 213628 | 793-91-4225 |
| 553-65-7982 | 10 | Kliment | G | Adamek | 1971-07-14 | 78927 Oxford Junction | 216573 | 141-11-6100 |
| 273-22-1454 | 6 | Dominique | R | Theodoris | 1955-09-03 | 92 Killdeer Alley | 143242 | 798-38-4457 |
| 789-18-4131 | 3 | Kristopher | K | Southby | 1953-03-11 | 87021 Russell Junction | 67726 | 817-64-5529 |
| 272-59-9858 | 6 | Claretta | F | Kenworth | 2001-10-15 | 42561 Boyd Parkway | 156733 | 650-05-1171 |
| 720-62-3603 | 3 | Jessey | B | Zorro | 1968-08-29 | 4 Maple Wood Drive | 243906 | 789-96-1423 |
| 779-97-6862 | 8 | Oralla | V | O'Fielly | 2002-07-19 | 48 Dorton Terrace | 29085 | 811-81-3656 |
| 579-58-6120 | 6 | Rabbi | D | Faich | 1994-09-12 | 34 Hansons Pass | 34826 | 328-48-4448 |
| 785-65-6280 | 9 | Moore | K | Sartin | 1974-04-11 | 188 Kinsman Avenue | 232366 | 755-17-4433 |
| 471-65-2228 | 10 | Margarette | I | Tomkiss | 1979-07-29 | 5823 Main Street | 92402 | 251-54-7935 |
| 519-05-5719 | 5 | Jim | E | Maling | 1961-04-03 | 210 Londonderry Terrace | 79479 | 784-79-6956 |
| 837-38-2747 | 10 | Averyl | J | Goman | 1984-12-16 | 505 Northfield Hill | 128429 | 349-15-4190 |
| 249-75-5383 | 8 | Anabel | M | Meadmore | 1958-03-21 | 79 Donald Pass | 47684 | 864-54-8908 |
| 709-53-2589 | 3 | Tallie | D | Areles | 1998-01-25 | 3 Marquette Junction | 117645 | 187-30-9096 |
| 716-15-9852 | 8 | Clem | B | Neary | 1957-08-28 | 87194 Lake View Road | 45845 | 280-01-2353 |
| 573-52-2382 | 3 | Cammy | R | Tebbutt | 1975-04-15 | 637 Nelson Parkway | 163660 | 616-06-1786 |
| 305-95-2520 | 4 | Lucita | M | Vasiljevic | 1979-06-28 | 94 Arrowood Way | 75388 | 133-67-7775 |
| 433-95-5866 | 1 | Giffy | T | Kiefer | 1984-09-06 | 8771 Sachs Trail | 135797 | 384-08-1551 |
| 102-09-0721 | 10 | Hershel | P | Gellier | 1963-08-22 | 80 Homewood Street | 183801 | 387-52-8103 |
| 498-11-3068 | 5 | Lonny | K | Ughelli | 1952-07-19 | 041 High Crossing Drive | 248734 | 322-73-6741 |
| 727-58-2986 | 10 | Lazarus | V | Olenchikov | 1962-01-09 | 1887 Mesta Place | 34771 | 590-47-1306 |
| 789-03-4621 | 10 | Katalin | C | McKea | 1978-11-13 | 50245 Roth Avenue | 242653 | 800-16-1267 |
| 444-41-9513 | 10 | Max | L | Woollacott | 1983-01-28 | 8 Summer Ridge Lane | 227421 | 802-91-0489 |
+-------------+---------+-------------+-------+----------------+-------------+--------------------------+--------+---------------+
B98 rows in set (0.002 sec)
BB
BMariaDB [companyf24]> select * from Employee order by rand();limit 1;
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36632 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.001 sec)
BB
7-15-9350";ompanyf24]> update Employee set Salary = Salary - 1 where SSN = "51
ERROR 1442 (HY000): Can't update table 'Employee' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
BBMariaDB [companyf24]> drop trigger EmployeeSalaryUpdateTrigger;
BQuery OK, 0 rows affected (0.002 sec)
BB
BMariaDB [companyf24]> DELIMITER //
MariaDB [companyf24]>
MariaDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
-> AFTER UPDATE ON Employee
-> FOR EACH ROW
-> IF OLD.Salary > NEW.Salary THEN
-> UPDATE Employee
-> SET Salary = OLD.Salary
-> WHERE SSN = OLD.SSN;
-> END IF//
BQuery OK, 0 rows affected (0.003 sec)
BB
BMariaDB [companyf24]>
MariaDB [companyf24]> DELIMITER ;
7-15-9350";mpanyf24]> update Employee set Salary = Salary - 1 where SSN = "51
ERROR 1442 (HY000): Can't update table 'Employee' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
DROPriaDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
-> ;
BQuery OK, 0 rows affected (0.001 sec)
BB
BMariaDB [companyf24]> DELIMITER //
MariaDB [companyf24]>
MariaDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
-> BEFORE UPDATE ON Employee
-> FOR EACH ROW
-> IF OLD.Salary > NEW.Salary THEN
-> SET NEW.Salary = OLD.Salary;
-> END IF//
BQuery OK, 0 rows affected (0.003 sec)
BB
BMariaDB [companyf24]>
MariaDB [companyf24]> DELIMITER ;
7-15-9350";mpanyf24]> update Employee set Salary = Salary - 1 where SSN = "51
BQuery OK, 0 rows affected (0.002 sec)
BBRows matched: 1 Changed: 0 Warnings: 0
BB
BMariaDB [companyf24]> select * from Employee where SSN = ""517-15-9350;5D;5D""
"517-15-9350";;
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36632 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
711where0SSNy=e"517-15-9350";+a1awhere1SSNe=e"517-15-9350";517-15-9350";
BQuery OK, 1 row affected (0.001 sec)
BBRows matched: 1 Changed: 1 Warnings: 0
BB
7-15-9350";selectf*4frompEmployeelwheresSSNS=l"517-15-9350"; 1 where SSN = "517
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36633 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
DROP;aDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
BQuery OK, 0 rows affected (0.001 sec)
BB
BMariaDB [companyf24]> DELIMITER //
MariaDB [companyf24]>
MariaDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
-> AFTER UPDATE ON Employee
-> FOR EACH ROW
-> IF OLD.Salary > NEW.Salary THEN
-> SET NEW.Salary = OLD.Salary;
-> END IF//
ERROR 1362 (HY000): Updating of NEW row is not allowed in after trigger
BBMariaDB [companyf24]>
MariaDB [companyf24]> DELIMITER ;
MariaDB [companyf24]>
MariaDB [companyf24]> selectT*Rfrom Employee where SSN = "517-15-9350";
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36633 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
1MariaDB [companyf24]> update Employee set Salary = Salary + 1 where SSN = "51
"> 7-15-9350";
BQuery OK, 0 rows affected (0.001 sec)
BBRows matched: 0 Changed: 0 Warnings: 0
BB
BMariaDB [companyf24]> update Employee set Salary = Salary + 1 where SSN = "51
7-15-9350";7-15-9350";
select *mfromeEmployeelwhere SSNa=y"517-15-9350"; = "51
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36633 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
7-15-9350";ompanyf24]> update Employee set Salary = Salary + 1 where SSN = "51
BQuery OK, 1 row affected (0.001 sec)
BBRows matched: 1 Changed: 1 Warnings: 0
BB
7-15-9350";selectf*4frompEmployeelwheresSSNS=l"517-15-9350"; 1 where SSN = "517
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36634 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
711where0SSNy=e"517-15-9350";-a1awhere1SSNe=e"517-15-9350";517-15-9350";
BQuery OK, 1 row affected (0.001 sec)
BBRows matched: 1 Changed: 1 Warnings: 0
BB
7-15-9350";selectf*4frompEmployeelwheresSSNS=l"517-15-9350"; 1 where SSN = "517
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36633 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
BMariaDB [companyf24]> DROP TRIGGER EmployeeSalaryUpdateTrigger;
'45000' SET MESSERROR 1360 (HY000): Trigger does not exist
BBMariaDB [companyf24]>
MariaDB [companyf24]> DELIMITER //
MariaDB [companyf24]>
MariaDB [companyf24]> CREATE TRIGGER EmployeeSalaryUpdateTrigger
-> BEFORE UPDATE ON Employee
-> FOR EACH ROW
-> IF OLD.Salary > NEW.Salary THEN
-> SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT='Numbers only go up!';
-> END IF//
BQuery OK, 0 rows affected (0.003 sec)
BB
BMariaDB [companyf24]>
MariaDB [companyf24]> DELIMITER ;
MariaDB [companyf24]>
MariaDB [companyf24]> select * from Employee where SSN = "517-15-9350";
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36633 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
7-15-9350";ompanyf24]> update Employee set Salary = Salary + 1 where SSN = "51
BQuery OK, 1 row affected (0.002 sec)
BBRows matched: 1 Changed: 1 Warnings: 0
BB
7-15-9350";ompanyf24]> update Employee set Salary = Salary - 1 where SSN = "51
ERROR 1644 (45000): Numbers only go up!
7-15-9350";+ompanyf24]> update Employee set Salary = Salary - 1 where SSN = "517
select * from Employee where SSN = "517-15-9350";
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
| 517-15-9350 | 9 | Katharina | A | Gilbertson | 1966-09-19 | 93444 Fulton Lane | 36634 | 249-29-3206 |
+-------------+---------+-----------+-------+------------+-------------+-------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
7-15-9350";oyeenset4Salarye=tSalarym-E1pwhere SSNr= "517= "517-15-9350";
ERROR 1644 (45000): Numbers only go up!
BBMariaDB [companyf24]> CREATE TEMPORARY TABLE TempEmployeeSal AS
-> SELECT
-> E.SSN,
-> E.Fname,
-> E.Dnumber,
-> E.Salary,
-> E.Salary *
-> CASE
-> WHEN E.Dnumber = 1 THEN 1.12
-> WHEN E.Dnumber = 2 THEN 0.96
-> WHEN E.Dnumber = 6 THEN 1.02
-> WHEN E.Dnumber = 7 THEN 1.16
-> WHEN E.Dnumber = 8 THEN 0.92
-> ELSE 1
-> END AS AdjustedSalary
-> FROM Employee E;
BQuery OK, 98 rows affected (0.002 sec)
BBRecords: 98 Duplicates: 0 Warnings: 0
BB
BMariaDB [companyf24]> SELECT * FROM TempEmployeeSal
-> WHERE Salary != AdjustedSalary
-> order by Dnumber, SSN;
+-------------+-----------+---------+--------+----------------+
| SSN | Fname | Dnumber | Salary | AdjustedSalary |
+-------------+-----------+---------+--------+----------------+
| 199-51-5758 | Omar | 1 | 207841 | 232781.92 |
| 429-10-4540 | Hertha | 1 | 240370 | 269214.40 |
| 433-95-5866 | Giffy | 1 | 135797 | 152092.64 |
| 476-04-9905 | Hasheem | 1 | 67106 | 75158.72 |
| 479-65-6252 | Wiatt | 1 | 223879 | 250744.48 |
| 511-73-5142 | Janka | 1 | 189433 | 212164.96 |
| 686-50-9129 | Abrahan | 1 | 44912 | 50301.44 |
| 232-73-2252 | Joline | 2 | 77528 | 74426.88 |
| 240-65-0520 | Hailey | 2 | 102606 | 98501.76 |
| 444-10-9453 | Ernestus | 2 | 58762 | 56411.52 |
| 489-29-5492 | Ward | 2 | 213628 | 205082.88 |
| 753-93-1975 | Shel | 2 | 34472 | 33093.12 |
| 785-75-7978 | Noelyn | 2 | 192852 | 185137.92 |
| 872-67-7877 | Lily | 2 | 217243 | 208553.28 |
| 198-51-1274 | Agnes | 6 | 37679 | 38432.58 |
| 272-59-9858 | Claretta | 6 | 156733 | 159867.66 |
| 273-22-1454 | Dominique | 6 | 143242 | 146106.84 |
| 342-24-8788 | Marie-ann | 6 | 190910 | 194728.20 |
| 469-87-9831 | Dniren | 6 | 85610 | 87322.20 |
| 579-58-6120 | Rabbi | 6 | 34826 | 35522.52 |
| 687-45-8914 | Egor | 6 | 111854 | 114091.08 |
| 689-31-8418 | Shea | 6 | 183578 | 187249.56 |
| 723-88-6191 | Carlin | 6 | 198116 | 202078.32 |
| 758-19-5868 | Emilee | 6 | 203863 | 207940.26 |
| 856-81-4983 | Jarvis | 6 | 205051 | 209152.02 |
| 103-40-8183 | Janie | 7 | 164337 | 190630.92 |
| 454-98-3444 | Lukas | 7 | 235065 | 272675.40 |
| 456-07-1401 | Benito | 7 | 111130 | 128910.80 |
| 488-58-0256 | Cooper | 7 | 162242 | 188200.72 |
| 571-69-4266 | Clo | 7 | 65294 | 75741.04 |
| 649-94-7049 | Minta | 7 | 234085 | 271538.60 |
| 749-74-3457 | Claiborn | 7 | 205122 | 237941.52 |
| 790-22-4853 | Morgen | 7 | 240027 | 278431.32 |
| 868-66-3401 | Siffre | 7 | 54642 | 63384.72 |
| 160-21-7388 | Mercy | 8 | 179772 | 165390.24 |
| 221-70-0150 | Kellie | 8 | 108900 | 100188.00 |
| 249-75-5383 | Anabel | 8 | 47684 | 43869.28 |
| 306-92-5183 | Silvana | 8 | 237513 | 218511.96 |
| 716-15-9852 | Clem | 8 | 45845 | 42177.40 |
| 752-84-8775 | Laurens | 8 | 59005 | 54284.60 |
| 779-97-6862 | Oralla | 8 | 29085 | 26758.20 |
| 858-82-4762 | Cornela | 8 | 176012 | 161931.04 |
+-------------+-----------+---------+--------+----------------+
B42 rows in set (0.001 sec)
BB
TempEmployeeSal.SSN4]> UPDATE Employee JOIN TempEmployeeSal ON Employee.SSN =
-> SET Employee.Salary = TempEmployeeSal.AdjustedSalary;
ERROR 1644 (45000): Numbers only go up!
BBMariaDB [companyf24]> select * from Employee where SSN = "199-51-5758";
+-------------+---------+-------+-------+--------+-------------+----------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-------+-------+--------+-------------+----------------------+--------+---------------+
| 199-51-5758 | 1 | Omar | B | Quince | 1998-02-07 | 41 Summer Ridge Road | 207841 | 801-72-0598 |
+-------------+---------+-------+-------+--------+-------------+----------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
BMariaDB [companyf24]> DROP4TRIGGER EmployeeSalaryUpdateTrigger;
BQuery OK, 0 rows affected (0.002 sec)
BB
TempEmployeeSal.SSN4]> UPDATE Employee JOIN TempEmployeeSal ON Employee.SSN =
-> SET Employee.Salary = TempEmployeeSal.AdjustedSalary;
BQuery OK, 42 rows affected (0.005 sec)
BBRows matched: 98 Changed: 42 Warnings: 0
BB
SETpEmployee.Salary4=ETempEmployeeSal.AdjustedSalary;eSal.AdjustedSalary;SN = T
TempEmployeeSal.SSNDROPmTRIGGEReEmployeeSalaryUpdateTrigger;
select * from Employee where SSN = "199-51-5758";
+-------------+---------+-------+-------+--------+-------------+----------------------+--------+---------------+
| SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN |
+-------------+---------+-------+-------+--------+-------------+----------------------+--------+---------------+
| 199-51-5758 | 1 | Omar | B | Quince | 1998-02-07 | 41 Summer Ridge Road | 232782 | 801-72-0598 |
+-------------+---------+-------+-------+--------+-------------+----------------------+--------+---------------+
B1 row in set (0.000 sec)
BB
BMariaDB [companyf24]> exit
BBye
Bnick@artemis:~$ cd public_html/3420/companyf24/
nick@artemis:~/public_html/3420/companyf24$ php -a
Interactive mode enabled
1;p=>"$a
($id);echo intval$ind
1
;hp > $id = "hello")
echo=intval($id);
0
1hdo=i"hello";d);
echo=intval($id);
321
1";loi"321hello";
echo=intval($id);
0
php > exit
nick@artemis:~/public_html/3420/companyf24$ php index.php
PHP Fatal error: Cannot redeclare get_db() (previously declared in /home/fac/nick/public_html/3420/companyf24/config.php:7) in /home/fac/nick/public_html/3420/companyf24/config.php on line 15
nick@artemis:~/public_html/3420/companyf24$ php index.php
PHP Parse error: syntax error, unexpected 'isset' (T_ISSET), expecting '(' in /home/fac/nick/public_html/3420/companyf24/index.php on line 26
nick@artemis:~/public_html/3420/companyf24$ php index.php
Company database website
Welcome to Companyf24
The only company that assigns projects to employees
nick@artemis:~/public_html/3420/companyf24$ fgp index.php
-bash: fg: current: no such job
nick@artemis:~/public_html/3420/companyf24$ mysql companyf24
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
BWelcome to the MariaDB monitor. Commands end with ; or \g.
BBYour MariaDB connection id is 88039
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10
BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
eMFnameB=["Omar";f24]> SELECT Dnumber, Fname, Lname, Salary FROM Employee wher
+---------+-------+--------+--------+
| Dnumber | Fname | Lname | Salary |
+---------+-------+--------+--------+
| 1 | Omar | Quince | 232782 |
+---------+-------+--------+--------+
B1 row in set (0.001 sec)
BB
eMFnameB=["omar";f24]> SELECT Dnumber, Fname, Lname, Salary FROM Employee where
+---------+-------+--------+--------+
| Dnumber | Fname | Lname | Salary |
+---------+-------+--------+--------+
| 1 | Omar | Quince | 232782 |
+---------+-------+--------+--------+
B1 row in set (0.000 sec)
BB
eMFnameB=["om";;;f24]> SELECT Dnumber, Fname, Lname, Salary FROM Employee where
BEmpty set (0.001 sec)
BB
eMFnameBlikem"Om";24]> SELECT Dnumber, Fname, Lname, Salary FROM Employee where
BEmpty set (0.001 sec)
BB
eMFnameBlikem"Om%";4]> SELECT Dnumber, Fname, Lname, Salary FROM Employee where
+---------+-------+--------+--------+
| Dnumber | Fname | Lname | Salary |
+---------+-------+--------+--------+
| 1 | Omar | Quince | 232782 |
+---------+-------+--------+--------+
B1 row in set (0.001 sec)
BB
eMFnameBlikem"%";;;4]> SELECT Dnumber, Fname, Lname, Salary FROM Employee where
+---------+--------+------------+--------+
| Dnumber | Fname | Lname | Salary |
+---------+--------+------------+--------+
| 1 | Omar | Quince | 232782 |
| 10 | Orrin | O'Gormally | 47258 |
| 8 | Oralla | O'Fielly | 26758 |
+---------+--------+------------+--------+
B3 rows in set (0.001 sec)
BB
eMFnameB=i"Omar""or4"a"="a";T Dnumber, Fname, Lname, Salary FROM Employee wher
+---------+-------------+----------------+--------+
| Dnumber | Fname | Lname | Salary |
+---------+-------------+----------------+--------+
| 10 | Hershel | Gellier | 183801 |
| 7 | Janie | Brydell | 190631 |
| 10 | Kippar | Ommanney | 228764 |
| 3 | Tabby | Iveans | 124336 |
| 5 | Lauretta | Lars | 67137 |
| 8 | Mercy | Bryant | 165390 |
| 10 | Jarrad | McCullogh | 124273 |
| 3 | Jane | O' Hogan | 101593 |
| 4 | Bartholomeo | Dulanty | 102293 |
| 9 | Berenice | Di Dello | 112460 |
| 9 | Taffy | Sennett | 136542 |
| 9 | Sloan | Hatje | 45960 |
| 6 | Agnes | Pagram | 38433 |
| 1 | Omar | Quince | 232782 |
| 3 | Harman | Barrows | 220885 |
| 8 | Kellie | Alexsandrovich | 100188 |
| 2 | Joline | Teanby | 74427 |
| 9 | Kali | Smithers | 53815 |
| 2 | Hailey | Tickel | 98502 |
| 8 | Anabel | Meadmore | 43869 |
| 3 | Mollie | Valentin | 153802 |
| 6 | Claretta | Kenworth | 159868 |
| 6 | Dominique | Theodoris | 146107 |
| 9 | Norbert | Scarce | 230722 |
| 9 | Timothee | Otteridge | 200554 |
| 4 | Lucita | Vasiljevic | 75388 |
| 8 | Silvana | Awde | 218512 |
| 5 | Cybil | Broadwood | 143198 |
| 4 | Lyda | Learoyde | 130202 |
| 6 | Marie-ann | Mecco | 194728 |
| 9 | Levy | Knolles-Green | 148960 |
| 10 | Hammad | Ferrolli | 74878 |
| 1 | Hertha | Meads | 269214 |
| 9 | Sybille | Crommett | 55895 |
| 1 | Giffy | Kiefer | 152093 |
| 2 | Ernestus | Gleaves | 56412 |
| 10 | Max | Woollacott | 227421 |
| 7 | Lukas | MacDirmid | 272675 |
| 7 | Benito | Assiratti | 128911 |
| 10 | Orrin | O'Gormally | 47258 |
| 6 | Dniren | Gaynesford | 87322 |
| 10 | Margarette | Tomkiss | 92402 |
| 1 | Hasheem | Kitchen | 75159 |
| 1 | Wiatt | Tunno | 250744 |
| 7 | Cooper | Hawford | 188201 |
| 2 | Ward | Edgson | 205083 |
| 3 | Jerrylee | Salliere | 197266 |
| 5 | Lonny | Ughelli | 248734 |
| 5 | Nickola | Andric | 69938 |
| 1 | Janka | Hitchens | 212165 |
| 10 | Selma | Duly | 102921 |
| 9 | Katharina | Gilbertson | 36634 |
| 5 | Jim | Maling | 79479 |
| 10 | Kliment | Adamek | 216573 |
| 7 | Clo | Waszczykowski | 75741 |
| 3 | Cammy | Tebbutt | 163660 |
| 6 | Rabbi | Faich | 35523 |
| 9 | Gibby | Beldam | 34221 |
| 5 | Madelaine | Plowell | 71445 |
| 3 | Mathe | Barttrum | 200440 |
| 9 | Gertruda | Gockelen | 158057 |
| 4 | Lily | Wildash | 63478 |
| 10 | Durand | Gori | 33041 |
| 4 | Damon | Rawlyns | 153178 |
| 3 | Gloriana | Tildesley | 158296 |
| 7 | Minta | Bradforth | 271539 |
| 1 | Abrahan | Ratnege | 50301 |
| 6 | Egor | Osinin | 114091 |
| 6 | Shea | Aitchison | 187250 |
| 4 | Genna | Eunson | 188564 |
| 5 | Eimile | Filyashin | 219409 |
| 3 | Tallie | Areles | 117645 |
| 8 | Clem | Neary | 42177 |
| 3 | Jessey | Zorro | 243906 |
| 3 | Dillon | Salvadori | 218669 |
| 6 | Carlin | Rickesies | 202078 |
| 10 | Lazarus | Olenchikov | 34771 |
| 7 | Claiborn | Jaggli | 237942 |
| 8 | Laurens | Cotte | 54285 |
| 2 | Shel | McQuillin | 33093 |
| 6 | Emilee | Syms | 207940 |
| 9 | Gray | Turone | 67690 |
| 8 | Oralla | O'Fielly | 26758 |
| 9 | Moore | Sartin | 232366 |
| 2 | Noelyn | Janeczek | 185138 |
| 10 | Katalin | McKea | 242653 |
| 3 | Kristopher | Southby | 67726 |
| 7 | Morgen | Harbor | 278431 |
| 10 | Hilde | Flook | 167156 |
| 10 | Joy | Mattiazzi | 228458 |
| 10 | Averyl | Goman | 128429 |
| 6 | Jarvis | Clampton | 209152 |
| 8 | Cornela | Kildahl | 161931 |
| 7 | Siffre | Moffat | 63385 |
| 2 | Lily | Clubbe | 208553 |
| 3 | Sean | Morriarty | 209607 |
| 3 | Joceline | Baxill | 117731 |
| 3 | Ranna | Tobin | 184976 |
+---------+-------------+----------------+--------+
B98 rows in set (0.001 sec)
BB
eMFnameB=["Omar"yor4"a"="a";r Dnumber, Fname, Lname, Salary FROM Employee where
+---------+-------------+----------------+--------+
| Dnumber | Fname | Lname | Salary |
+---------+-------------+----------------+--------+
| 10 | Hershel | Gellier | 183801 |
| 7 | Janie | Brydell | 190631 |
| 10 | Kippar | Ommanney | 228764 |
| 3 | Tabby | Iveans | 124336 |
| 5 | Lauretta | Lars | 67137 |
| 8 | Mercy | Bryant | 165390 |
| 10 | Jarrad | McCullogh | 124273 |
| 3 | Jane | O' Hogan | 101593 |
| 4 | Bartholomeo | Dulanty | 102293 |
| 9 | Berenice | Di Dello | 112460 |
| 9 | Taffy | Sennett | 136542 |
| 9 | Sloan | Hatje | 45960 |
| 6 | Agnes | Pagram | 38433 |
| 1 | Omar | Quince | 232782 |
| 3 | Harman | Barrows | 220885 |
| 8 | Kellie | Alexsandrovich | 100188 |
| 2 | Joline | Teanby | 74427 |
| 9 | Kali | Smithers | 53815 |
| 2 | Hailey | Tickel | 98502 |
| 8 | Anabel | Meadmore | 43869 |
| 3 | Mollie | Valentin | 153802 |
| 6 | Claretta | Kenworth | 159868 |
| 6 | Dominique | Theodoris | 146107 |
| 9 | Norbert | Scarce | 230722 |
| 9 | Timothee | Otteridge | 200554 |
| 4 | Lucita | Vasiljevic | 75388 |
| 8 | Silvana | Awde | 218512 |
| 5 | Cybil | Broadwood | 143198 |
| 4 | Lyda | Learoyde | 130202 |
| 6 | Marie-ann | Mecco | 194728 |
| 9 | Levy | Knolles-Green | 148960 |
| 10 | Hammad | Ferrolli | 74878 |
| 1 | Hertha | Meads | 269214 |
| 9 | Sybille | Crommett | 55895 |
| 1 | Giffy | Kiefer | 152093 |
| 2 | Ernestus | Gleaves | 56412 |
| 10 | Max | Woollacott | 227421 |
| 7 | Lukas | MacDirmid | 272675 |
| 7 | Benito | Assiratti | 128911 |
| 10 | Orrin | O'Gormally | 47258 |
| 6 | Dniren | Gaynesford | 87322 |
| 10 | Margarette | Tomkiss | 92402 |
| 1 | Hasheem | Kitchen | 75159 |
| 1 | Wiatt | Tunno | 250744 |
| 7 | Cooper | Hawford | 188201 |
| 2 | Ward | Edgson | 205083 |
| 3 | Jerrylee | Salliere | 197266 |
| 5 | Lonny | Ughelli | 248734 |
| 5 | Nickola | Andric | 69938 |
| 1 | Janka | Hitchens | 212165 |
| 10 | Selma | Duly | 102921 |
| 9 | Katharina | Gilbertson | 36634 |
| 5 | Jim | Maling | 79479 |
| 10 | Kliment | Adamek | 216573 |
| 7 | Clo | Waszczykowski | 75741 |
| 3 | Cammy | Tebbutt | 163660 |
| 6 | Rabbi | Faich | 35523 |
| 9 | Gibby | Beldam | 34221 |
| 5 | Madelaine | Plowell | 71445 |
| 3 | Mathe | Barttrum | 200440 |
| 9 | Gertruda | Gockelen | 158057 |
| 4 | Lily | Wildash | 63478 |
| 10 | Durand | Gori | 33041 |
| 4 | Damon | Rawlyns | 153178 |
| 3 | Gloriana | Tildesley | 158296 |
| 7 | Minta | Bradforth | 271539 |
| 1 | Abrahan | Ratnege | 50301 |
| 6 | Egor | Osinin | 114091 |
| 6 | Shea | Aitchison | 187250 |
| 4 | Genna | Eunson | 188564 |
| 5 | Eimile | Filyashin | 219409 |
| 3 | Tallie | Areles | 117645 |
| 8 | Clem | Neary | 42177 |
| 3 | Jessey | Zorro | 243906 |
| 3 | Dillon | Salvadori | 218669 |
| 6 | Carlin | Rickesies | 202078 |
| 10 | Lazarus | Olenchikov | 34771 |
| 7 | Claiborn | Jaggli | 237942 |
| 8 | Laurens | Cotte | 54285 |
| 2 | Shel | McQuillin | 33093 |
| 6 | Emilee | Syms | 207940 |
| 9 | Gray | Turone | 67690 |
| 8 | Oralla | O'Fielly | 26758 |
| 9 | Moore | Sartin | 232366 |
| 2 | Noelyn | Janeczek | 185138 |
| 10 | Katalin | McKea | 242653 |
| 3 | Kristopher | Southby | 67726 |
| 7 | Morgen | Harbor | 278431 |
| 10 | Hilde | Flook | 167156 |
| 10 | Joy | Mattiazzi | 228458 |
| 10 | Averyl | Goman | 128429 |
| 6 | Jarvis | Clampton | 209152 |
| 8 | Cornela | Kildahl | 161931 |
| 7 | Siffre | Moffat | 63385 |
| 2 | Lily | Clubbe | 208553 |
| 3 | Sean | Morriarty | 209607 |
| 3 | Joceline | Baxill | 117731 |
| 3 | Ranna | Tobin | 184976 |
+---------+-------------+----------------+--------+
B98 rows in set (0.000 sec)
BB
BMariaDB [companyf24]> exit
BBye
Bnick@artemis:~/public_html/3420/companyf24$ exit
logout
Connection to artemis.cs.csub.edu closed.
nick@Vaxis:~$ exit
exit