nick@Vaxis:~$ ssh artemis Linux artemis 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) 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: Tue Mar 14 14:30:20 2023 from 136.168.35.3 nick@artemis:~$ mysql division 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 31195 Server version: 10.3.36-MariaDB-0+deb10u2 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 [division]> show databases; +---------------------+ | Database | +---------------------+ | 3420_timeslots | | 4420s23 | | aalmanza | | aamistoso | | aarcosavalos | | aattiaibrahi | | abotello | | acardenassil | | acazares | | adiazperez | | aesa | | ailarde | | amanz | | amartinez | | amilin | | anicholas | | apacheco | | aparriott | | apea | | aportillo | | atorres | | autosource | | avu | | azacariasvil | | bayapantecat | | bbowers | | benco | | bibliotech | | bjones | | blockbuster2 | | bobabuddy | | booksbooksbooks | | bookworm | | bparsons | | btate | | buddydj | | cart_pushers | | cestes | | cgallegos | | chatroom | | chernandez | | cmartinez | | cnavarro | | cokpara | | company | | companys23 | | ctennison | | danzaldo | | dbalderas | | dcasas | | dcerrato | | deejayscafe | | dfanucchi | | dgonzalez | | dgonzalez2 | | division | | djosep | | dlopez | | dmacias | | dmesa | | dontpanic | | dpham | | drivera | | dsimpson | | dtorres | | dware | | dwelch | | earroyo | | ecastaneda | | eescutiaeche | | efelicidario | | egamino | | ehsan_demo | | ekyles | | eldenbees | | emckenna | | employees | | eosornio | | eposting | | eramossorian | | erosales | | esnopko | | etagaca | | etapiaramire | | ewarren | | financingfordummies | | flightclub | | flin | | furniture_store | | furryfriendfinder | | gcaragchiu | | gititfresh | | gjimenez | | gjimenezroja | | grading_lab6 | | gtorres | | guilddb | | gymtraffic | | gzepeda | | hallen | | hardwaremerchants | | hayleeco | | hbal | | hcheema | | hellodb | | hmartinez | | hmmc | | honestcollective | | hotelbookingsystem | | hpascual | | ichavez | | imacias | | inerizavala | | inform_a_fish | | information_schema | | ingredients_proj | | iruiz | | jambriz | | jarenas | | jarzate | | jbankston | | jcox | | jflanders | | jflores | | jguarcasgarc | | jhicks | | jjellie | | jkuo | | jmiranda | | jnukpese | | jparks | | jpereyra | | jquinonez | | jrodriguez | | jrojas | | jsierradiaz | | jsoto | | jtagaca | | julloa | | kcarrillo | | kcoggshall | | klappin | | ksantiago | | lab6 | | laguilar | | ldiaz | | learnapp | | lgamboa | | librarymanpreet | | lmoreno | | lost+found | | lost_items | | lostchapter | | luxuryautomotives | | macosta | | mail_verify | | mangeles | | mbuenonunez | | mcha | | mdeguia | | mealdb | | mervin | | mestrada | | metchison | | mfuentesrive | | mgutierrez | | mjimenez | | mlara | | mlara2 | | moviedb | | msaini | | mschmidt | | msteiner | | mtaylor | | mvargas | | mwisehart | | myhealthypet | | mysql | | nanocenter | | nanocenter2 | | nanocenterv2 | | nchiang | | nflessati | | nick | | nleyvarodrig | | npitts | | nromasanta | | ocastillo | | paypool | | pcruz | | performance_schema | | plantpage | | ppark | | prodriguez | | pzavala | | quizdemo | | ramrod | | rateem | | rateem2 | | rcorona | | readymedi | | restaurant | | rgordon | | rgrewal | | rmanzo | | rmojica | | rocket_power | | rpatel | | rplascencia | | runnerpp | | rvelasquez | | rwyatt | | sabdulrazzak | | scarlos | | sdenney | | sercoli | | sesquivel | | sflores | | sjue | | skaing | | skurtz | | sledwell | | sleep_tracker | | smayfieldsmi | | smclaughlin | | snez | | sparksocial | | srasapatirat | | ssingh | | stay_fresh | | steve | | subscriptions | | svargas | | teamo7 | | thooser | | thriftstore | | timesheet | | tradespace | | ufcdb | | unreliablenarrator | | useraccountsdemo | | usingh | | xreyes | | ybond | | zgarcia | +---------------------+ B245 rows in set (0.002 sec) BB BMariaDB [division]> use companys23; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BDatabase changed BMariaDB [companys23]> show tables; +----------------------+ | Tables_in_companys23 | +----------------------+ | Department | | DepartmentLocations | | Dependent | | Employee | | Project | | WorksOn | +----------------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from Employee; BEmpty set (0.000 sec) BB BMariaDB [companys23]> describe Employee; +-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | SSN | char(9) | NO | PRI | NULL | | | Fname | varchar(20) | NO | | NULL | | | Minit | char(1) | YES | | NULL | | | Lname | varchar(20) | NO | | NULL | | | Bdate | date | YES | | NULL | | | Address | varchar(100) | YES | | NULL | | | Salary | decimal(14,2) | YES | | NULL | | | Super_SSN | char(9) | YES | MUL | NULL | | | Dnumber | int(11) | YES | MUL | NULL | | +-----------+---------------+------+-----+---------+-------+ B9 rows in set (0.001 sec) BB BMariaDB [companys23]> exit BBye Bnick@artemis:~$ cd 3420/company/s s23/ sp/ nick@artemis:~$ cd 3420/company/s s23/ sp/ nick@artemis:~$ cd 3420/company/s23 nick@artemis:~/3420/company/s23$ ls -l total 100 -rw-r--r-- 1 nick nick 33844 Mar 6 14:04 company.dump.sql -rw-r--r-- 1 nick nick 6474 Mar 6 14:03 companys23.dump.sql -rw-rw-r-- 1 nick nick 1735 Mar 15 13:36 company.sql -rw-r--r-- 1 nick nick 15218 Mar 15 13:35 Employee.sql -rw-r--r-- 1 nick nick 33988 Mar 6 14:12 somefile.txt nick@artemis:~/3420/company/s23$ mysql companys23 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 31309 Server version: 10.3.36-MariaDB-0+deb10u2 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 [companys23]> source company.sql BQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.003 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.005 sec) BB BBQuery OK, 0 rows affected (0.005 sec) BB BQuery:OK,o0 rowsnaffectede(0.010 sec) of stage done BBRecords: 0 Duplicates: 0 Warnings: 0 BB BBQuery OK, 0 rows affected (0.003 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BBQuery OK, 0 rows affected (0.003 sec) BB BMariaDB [companys23]> source Employee.sql BQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BMariaDB [companys23]> select * from Employee; +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-----------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-----------+---------+ | 108-30-6419 | Fredra | NULL | MacIlriach | 1920-04-04 | 43 South Court | 46783.00 | NULL | NULL | | 112-77-5572 | Shelby | NULL | Smethurst | 1973-09-29 | 05 Donald Park | 84462.00 | NULL | NULL | | 134-43-6596 | Maurine | NULL | Gibbonson | 1927-12-24 | 50253 Haas Hill | 62122.00 | NULL | NULL | | 155-65-2686 | Sandi | NULL | Berni | 1910-09-19 | 42355 Fremont Avenue | 74728.00 | NULL | NULL | | 157-88-7908 | Anna | NULL | Lissandri | 1972-04-12 | 104 Hagan Pass | 60820.00 | NULL | NULL | | 169-88-1613 | Marietta | NULL | Dawidowitz | 1951-03-07 | 17032 Tennessee Crossing | 22283.00 | NULL | NULL | | 178-09-9074 | Ella | NULL | Wollard | 1910-07-03 | 2392 Tomscot Alley | 87538.00 | NULL | NULL | | 180-68-1912 | Dania | NULL | Felipe | 1996-10-12 | 07274 Cordelia Place | 89565.00 | NULL | NULL | | 195-36-4688 | Henri | NULL | Handasyde | 1980-08-30 | 152 1st Street | 43031.00 | NULL | NULL | | 199-45-7914 | Tabbatha | NULL | Nelmes | 1984-06-06 | 8 Bayside Terrace | 39556.00 | NULL | NULL | | 206-42-6778 | Borg | NULL | Tonks | 1928-12-25 | 2085 International Court | 54754.00 | NULL | NULL | | 218-15-2428 | Templeton | NULL | Southerton | 1968-04-09 | 74 Lighthouse Bay Plaza | 16122.00 | NULL | NULL | | 221-78-4352 | Abbe | NULL | Halson | 1962-04-14 | 00 Esch Terrace | 49285.00 | NULL | NULL | | 224-05-5365 | Walton | NULL | Stolworthy | 1987-06-21 | 6992 Independence Terrace | 102697.00 | NULL | NULL | | 248-16-5831 | Melvin | NULL | Cockshut | 1947-06-14 | 56 Union Center | 70895.00 | NULL | NULL | | 250-42-9823 | Pierette | NULL | Thyer | 1960-04-03 | 8 Waywood Place | 25267.00 | NULL | NULL | | 250-45-6366 | Valina | NULL | Witch | 1916-07-01 | 7 Northland Alley | 107406.00 | NULL | NULL | | 250-86-3243 | Gail | NULL | Sacker | 1991-11-29 | 1 Thackeray Drive | 91616.00 | NULL | NULL | | 252-70-1281 | Yoshi | NULL | Kulver | 1990-03-07 | 1716 Myrtle Lane | 24717.00 | NULL | NULL | | 259-67-9909 | Tanitansy | NULL | Fragino | 1957-01-28 | 17 Milwaukee Alley | 105180.00 | NULL | NULL | | 259-69-3521 | Huey | NULL | Hertwell | 1948-05-27 | 0 Linden Alley | 16424.00 | NULL | NULL | | 279-97-0698 | Emilie | NULL | MacGahey | 1936-06-26 | 22 Shoshone Lane | 116060.00 | NULL | NULL | | 301-24-1567 | Haydon | NULL | Kimmel | 1963-06-13 | 62 Ohio Avenue | 72145.00 | NULL | NULL | | 310-24-7033 | Garrick | NULL | Greaves | 1952-07-24 | 416 Bowman Lane | 42650.00 | NULL | NULL | | 311-57-2543 | Darnell | NULL | Prosek | 1978-04-11 | 63 Clarendon Junction | 94333.00 | NULL | NULL | | 327-45-5907 | Cob | NULL | Tattoo | 1991-01-05 | 5 Village Green Way | 29381.00 | NULL | NULL | | 356-90-7571 | Saunder | NULL | Penney | 1981-03-16 | 27299 Lake View Drive | 85364.00 | NULL | NULL | | 357-26-8858 | Nissy | NULL | Matteotti | 1903-10-22 | 22 Lakewood Gardens Pass | 72048.00 | NULL | NULL | | 368-34-7197 | Angel | NULL | Mathivat | 1995-04-08 | 665 Scoville Trail | 104433.00 | NULL | NULL | | 369-50-5680 | Derby | NULL | Twohig | 1942-06-26 | 0 Golden Leaf Circle | 14023.00 | NULL | NULL | | 375-34-0891 | Evan | NULL | Fancet | 1919-09-15 | 875 Hovde Alley | 29485.00 | NULL | NULL | | 407-66-4296 | Stinky | NULL | Sterke | 1955-02-16 | 64893 Saint Paul Plaza | 13527.00 | NULL | NULL | | 414-10-4271 | Gerrie | NULL | Pentony | 1921-03-05 | 931 Bellgrove Alley | 100074.00 | NULL | NULL | | 439-93-4732 | Sibby | NULL | Cressor | 1922-09-03 | 92310 Carberry Parkway | 77597.00 | NULL | NULL | | 440-89-5164 | Jehu | NULL | Ropking | 1977-03-11 | 963 Kim Road | 83639.00 | NULL | NULL | | 442-52-4791 | Cristobal | NULL | Aven | 1958-01-17 | 5174 Sycamore Terrace | 17619.00 | NULL | NULL | | 447-39-2466 | Launce | NULL | Bewley | 1981-02-07 | 54802 Kingsford Park | 84652.00 | NULL | NULL | | 449-14-0909 | Marcos | NULL | Burr | 1977-06-16 | 8 Schurz Pass | 113462.00 | NULL | NULL | | 463-13-5723 | Wylie | NULL | Stanley | 1950-01-16 | 1153 Trailsway Circle | 89016.00 | NULL | NULL | | 467-54-3176 | Ora | NULL | Walrond | 1972-07-29 | 8 La Follette Point | 11450.00 | NULL | NULL | | 476-67-1971 | Carrie | NULL | Chansonnau | 1917-11-18 | 84 Service Terrace | 115335.00 | NULL | NULL | | 484-58-1616 | Pauly | NULL | Bowman | 1969-04-17 | 7444 5th Court | 58473.00 | NULL | NULL | | 486-81-9989 | Asher | NULL | Sleney | 1968-02-11 | 1 Bashford Trail | 91245.00 | NULL | NULL | | 489-86-9980 | Darlleen | NULL | Juckes | 1949-06-07 | 26981 6th Way | 81692.00 | NULL | NULL | | 508-50-6186 | Hillary | NULL | Leathers | 1903-09-22 | 79 Independence Hill | 84218.00 | NULL | NULL | | 515-40-9765 | Quillan | NULL | Fenge | 1949-09-11 | 9 Spaight Place | 79702.00 | NULL | NULL | | 519-28-6669 | Kyla | NULL | Corwin | 1972-05-13 | 97 David Road | 21637.00 | NULL | NULL | | 521-40-4757 | Arri | NULL | Bye | 1931-10-19 | 7 Sauthoff Terrace | 29068.00 | NULL | NULL | | 521-52-7799 | Kelley | NULL | Jaher | 1913-06-29 | 869 Iowa Drive | 68023.00 | NULL | NULL | | 526-92-5991 | Carita | NULL | Grievson | 1947-11-05 | 1 Grim Terrace | 107154.00 | NULL | NULL | | 532-76-3517 | Rozalin | NULL | Chilcotte | 1990-12-15 | 5513 Birchwood Way | 113445.00 | NULL | NULL | | 533-85-8477 | Winthrop | NULL | Whitrod | 1997-04-25 | 84759 Pankratz Hill | 56117.00 | NULL | NULL | | 536-16-5537 | Vladimir | NULL | Hayller | 1944-08-25 | 90276 5th Crossing | 45153.00 | NULL | NULL | | 543-29-8929 | Shawn | NULL | Clell | 1910-07-09 | 45225 Algoma Alley | 28033.00 | NULL | NULL | | 548-58-9075 | Lincoln | NULL | Dimitriev | 1926-03-16 | 522 Evergreen Pass | 111873.00 | NULL | NULL | | 554-96-0793 | Modesty | NULL | Tattoo | 1944-11-05 | 56790 Muir Park | 98339.00 | NULL | NULL | | 575-99-3134 | June | NULL | De Gouy | 1901-10-08 | 43890 Mccormick Center | 28310.00 | NULL | NULL | | 575-99-5872 | Dennie | NULL | Deeney | 1928-08-28 | 552 Lunder Avenue | 31020.00 | NULL | NULL | | 581-28-8564 | Bernie | NULL | Neggrini | 1912-03-04 | 5 Scott Circle | 90706.00 | NULL | NULL | | 596-37-9209 | Jilli | NULL | Moan | 1972-11-22 | 40 Kim Court | 80743.00 | NULL | NULL | | 600-82-6063 | Gates | NULL | Jacobowits | 1927-09-17 | 0 Eggendart Junction | 64355.00 | NULL | NULL | | 608-12-4879 | Kiersten | NULL | Pechan | 1948-12-29 | 91412 Debs Way | 26981.00 | NULL | NULL | | 609-89-7019 | Darelle | NULL | Colls | 1950-04-21 | 79957 Paget Hill | 53247.00 | NULL | NULL | | 615-18-6818 | Janean | NULL | Azam | 1914-10-14 | 83 Upham Drive | 26517.00 | NULL | NULL | | 622-30-0735 | Katine | NULL | Staff | 1911-06-22 | 00 Steensland Junction | 28688.00 | NULL | NULL | | 626-86-0981 | Hadley | NULL | Wallbutton | 1971-01-13 | 55 Elka Street | 55988.00 | NULL | NULL | | 632-84-2428 | Kiele | NULL | Boorne | 1923-10-04 | 06 Cascade Way | 111467.00 | NULL | NULL | | 640-78-3450 | Berkley | NULL | Jozwicki | 1934-02-24 | 880 Carey Drive | 56747.00 | NULL | NULL | | 645-74-0526 | Rodolphe | NULL | Bartolomieu | 1976-09-07 | 0326 Bultman Park | 13946.00 | NULL | NULL | | 645-89-3504 | Berny | NULL | Paragreen | 1971-06-15 | 82676 Old Shore Alley | 52840.00 | NULL | NULL | | 649-68-0970 | Parke | NULL | Commins | 1962-08-24 | 7 Starling Point | 83247.00 | NULL | NULL | | 658-02-8079 | Baryram | NULL | Duny | 1984-04-08 | 779 Lighthouse Bay Trail | 64044.00 | NULL | NULL | | 663-54-0337 | Gradeigh | NULL | Starbucke | 1987-08-01 | 14 Oakridge Road | 114335.00 | NULL | NULL | | 665-86-8548 | Vanni | NULL | Shorey | 1951-10-20 | 83068 Golf Course Hill | 87252.00 | NULL | NULL | | 676-04-3191 | Dimitri | NULL | Carter | 1943-09-02 | 2 Artisan Plaza | 24445.00 | NULL | NULL | | 688-21-1512 | Christabella | NULL | Shambrook | 1927-08-22 | 5 Huxley Park | 97957.00 | NULL | NULL | | 717-85-9172 | Ted | NULL | Peterson | 1983-04-05 | 491 Ronald Regan Hill | 104690.00 | NULL | NULL | | 720-58-9192 | Lacie | NULL | Woodyeare | 1945-07-12 | 6 Farwell Street | 58790.00 | NULL | NULL | | 725-13-9144 | Banky | NULL | Wright | 1907-10-14 | 40598 Center Drive | 23840.00 | NULL | NULL | | 730-73-1824 | Allyn | NULL | Peplay | 1982-06-05 | 2673 South Crossing | 59104.00 | NULL | NULL | | 735-36-0902 | Duky | NULL | Masser | 1972-07-23 | 01257 Florence Plaza | 45282.00 | NULL | NULL | | 740-55-0204 | Ty | NULL | Outibridge | 1983-11-09 | 0892 Aberg Street | 108147.00 | NULL | NULL | | 755-49-5779 | Esther | NULL | Martinetto | 1901-03-10 | 34 Marquette Lane | 88225.00 | NULL | NULL | | 769-08-1237 | Willie | NULL | Wakeley | 1991-05-31 | 30 Clemons Parkway | 110699.00 | NULL | NULL | | 785-69-1449 | Berthe | NULL | Pasfield | 1914-02-23 | 8880 Granby Trail | 42197.00 | NULL | NULL | | 788-79-8433 | Abbey | NULL | Scurman | 1951-08-18 | 2 Schurz Court | 23091.00 | NULL | NULL | | 799-59-0118 | Raff | NULL | Dymond | 1921-11-02 | 008 Hanson Pass | 67151.00 | NULL | NULL | | 801-55-5158 | Durward | NULL | O' Lone | 1983-07-23 | 08795 Gale Place | 67804.00 | NULL | NULL | | 803-13-5063 | Basil | NULL | Borkett | 1914-03-14 | 9 Autumn Leaf Circle | 95558.00 | NULL | NULL | | 827-84-9853 | Brietta | NULL | McKie | 1985-01-23 | 17 Lindbergh Parkway | 95141.00 | NULL | NULL | | 829-82-9898 | Lawry | NULL | Elsom | 1937-03-31 | 8 Nobel Hill | 30624.00 | NULL | NULL | | 831-68-7820 | Job | NULL | Wadforth | 1973-07-26 | 57 Nobel Plaza | 75210.00 | NULL | NULL | | 850-85-0292 | Constanta | NULL | Spindler | 1943-10-30 | 88 Harbort Lane | 61190.00 | NULL | NULL | | 851-37-9880 | Aggie | NULL | Pruvost | 1959-06-07 | 750 Mayfield Plaza | 60655.00 | NULL | NULL | | 852-63-0193 | Phil | NULL | Gabbott | 1955-08-30 | 22663 Sunfield Court | 106334.00 | NULL | NULL | | 855-68-5051 | Guinna | NULL | Bennoe | 1904-12-22 | 8 Dixon Road | 45806.00 | NULL | NULL | | 861-96-0479 | Jody | NULL | Purcell | 1943-02-18 | 8 Lawn Center | 80966.00 | NULL | NULL | | 862-55-5133 | Adolph | NULL | Lytton | 1937-10-11 | 0 Service Crossing | 28249.00 | NULL | NULL | | 874-24-1805 | Granthem | NULL | Tiffin | 1984-05-09 | 6731 Mandrake Drive | 92694.00 | NULL | NULL | | 893-15-9265 | Stefan | NULL | Tokley | 1917-07-24 | 74631 8th Place | 106871.00 | NULL | NULL | +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-----------+---------+ B100 rows in set (0.001 sec) BB BMariaDB [companys23]> select SSN from Employee ORDER BY RAND() LIMIT 10; +-------------+ | SSN | +-------------+ | 259-69-3521 | | 414-10-4271 | | 486-81-9989 | | 439-93-4732 | | 357-26-8858 | | 850-85-0292 | | 252-70-1281 | | 799-59-0118 | | 874-24-1805 | | 180-68-1912 | +-------------+ B10 rows in set (0.001 sec) BB BMariaDB [companys23]> select SSN from Employee ORDER BY RAND() LIMIT 10; +-------------+ | SSN | +-------------+ | 663-54-0337 | | 755-49-5779 | | 259-67-9909 | | 199-45-7914 | | 157-88-7908 | | 600-82-6063 | | 442-52-4791 | | 893-15-9265 | | 801-55-5158 | | 548-58-9075 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select SSN from Employee ORDER BY RAND() LIMIT 10; +-------------+ | SSN | +-------------+ | 157-88-7908 | | 554-96-0793 | | 663-54-0337 | | 414-10-4271 | | 407-66-4296 | | 439-93-4732 | | 649-68-0970 | | 615-18-6818 | | 851-37-9880 | | 645-74-0526 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select SSN from Employee ORDER BY RAND() LIMIT 10; +-------------+ | SSN | +-------------+ | 663-54-0337 | | 521-52-7799 | | 799-59-0118 | | 533-85-8477 | | 515-40-9765 | | 486-81-9989 | | 112-77-5572 | | 862-55-5133 | | 615-18-6818 | | 108-30-6419 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select SSN from Employee ORDER BY RAND() LIMIT 10; +-------------+ | SSN | +-------------+ | 720-58-9192 | | 259-67-9909 | | 357-26-8858 | | 250-86-3243 | | 735-36-0902 | | 532-76-3517 | | 893-15-9265 | | 548-58-9075 | | 178-09-9074 | | 862-55-5133 | +-------------+ B10 rows in set (0.001 sec) BB createDtemporaryytable uperviorsasfrom Employee ORDER BY RAND() LIMIT 10; ^[[ABQuery OK, 10 rows affected (0.001 sec) BBRecords: 10 Duplicates: 0 Warnings: 0 BB selectD* frompsupervisors;ate temporary table supervisors as select SSN from Employee ORDER BY RAND() LIMIT 10; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from supervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from supervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from supervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from supervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from supervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB BMariaDB [companys23]> updateeEmployee SET Super_SSN = (select SSN from supervisors order by rand() limit 1); ERROR 1406 (22001): Data too long for column 'Super_SSN' at row 2 BBMariaDB [companys23]> delete from Employee; BQuery OK, 100 rows affected (0.005 sec) BB BMariaDB [companys23]> source company.sql BQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.005 sec) BB BBQuery OK, 0 rows affected (0.005 sec) BB BQuery:OK,o0 rowsnaffectede(0.010 sec) of stage done BBRecords: 0 Duplicates: 0 Warnings: 0 BB BBQuery OK, 0 rows affected (0.003 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BBQuery OK, 0 rows affected (0.003 sec) BB BMariaDB [companys23]> source Employee.sql BQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.002 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BMariaDB [companys23]> select * from supervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB ourcemcompany.sqllableosupervisorseascselectfSSN;fromrEmployeerORDERyBYaRAND()iLIMIT)10; BQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.001 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.002 sec) BB BBQuery OK, 0 rows affected (0.000 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BQuery:OK,o0 rowsnaffectede(0.010 sec) of stage done BBRecords: 0 Duplicates: 0 Warnings: 0 BB BBQuery OK, 0 rows affected (0.003 sec) BB BBQuery OK, 0 rows affected (0.003 sec) BB BBQuery OK, 0 rows affected (0.004 sec) BB BBQuery OK, 0 rows affected (0.003 sec) BB ourceaEmployee.sql23]> select *ofromysupervisors; BQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB electa*mfromesupervisors;lect *ofromysupervisors; +-------------+ | SSN | +-------------+ | 279-97-0698 | | 508-50-6186 | | 785-69-1449 | | 467-54-3176 | | 622-30-0735 | | 155-65-2686 | | 301-24-1567 | | 327-45-5907 | | 484-58-1616 | | 874-24-1805 | +-------------+ B10 rows in set (0.000 sec) BB updatecEmployeelSETeSuper_SSN = (selectpSSNifrom;supervisors order by rand() limit 1); BQuery OK, 100 rows affected (0.008 sec) BBRows matched: 100 Changed: 100 Warnings: 0 BB BMariaDB [companys23]> select * from Employee; +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-------------+---------+ | 108-30-6419 | Fredra | NULL | MacIlriach | 1920-04-04 | 43 South Court | 46783.00 | 155-65-2686 | NULL | | 112-77-5572 | Shelby | NULL | Smethurst | 1973-09-29 | 05 Donald Park | 84462.00 | 484-58-1616 | NULL | | 134-43-6596 | Maurine | NULL | Gibbonson | 1927-12-24 | 50253 Haas Hill | 62122.00 | 622-30-0735 | NULL | | 155-65-2686 | Sandi | NULL | Berni | 1910-09-19 | 42355 Fremont Avenue | 74728.00 | 327-45-5907 | NULL | | 157-88-7908 | Anna | NULL | Lissandri | 1972-04-12 | 104 Hagan Pass | 60820.00 | 508-50-6186 | NULL | | 169-88-1613 | Marietta | NULL | Dawidowitz | 1951-03-07 | 17032 Tennessee Crossing | 22283.00 | 484-58-1616 | NULL | | 178-09-9074 | Ella | NULL | Wollard | 1910-07-03 | 2392 Tomscot Alley | 87538.00 | 785-69-1449 | NULL | | 180-68-1912 | Dania | NULL | Felipe | 1996-10-12 | 07274 Cordelia Place | 89565.00 | 327-45-5907 | NULL | | 195-36-4688 | Henri | NULL | Handasyde | 1980-08-30 | 152 1st Street | 43031.00 | 622-30-0735 | NULL | | 199-45-7914 | Tabbatha | NULL | Nelmes | 1984-06-06 | 8 Bayside Terrace | 39556.00 | 622-30-0735 | NULL | | 206-42-6778 | Borg | NULL | Tonks | 1928-12-25 | 2085 International Court | 54754.00 | 467-54-3176 | NULL | | 218-15-2428 | Templeton | NULL | Southerton | 1968-04-09 | 74 Lighthouse Bay Plaza | 16122.00 | 155-65-2686 | NULL | | 221-78-4352 | Abbe | NULL | Halson | 1962-04-14 | 00 Esch Terrace | 49285.00 | 622-30-0735 | NULL | | 224-05-5365 | Walton | NULL | Stolworthy | 1987-06-21 | 6992 Independence Terrace | 102697.00 | 467-54-3176 | NULL | | 248-16-5831 | Melvin | NULL | Cockshut | 1947-06-14 | 56 Union Center | 70895.00 | 785-69-1449 | NULL | | 250-42-9823 | Pierette | NULL | Thyer | 1960-04-03 | 8 Waywood Place | 25267.00 | 467-54-3176 | NULL | | 250-45-6366 | Valina | NULL | Witch | 1916-07-01 | 7 Northland Alley | 107406.00 | 155-65-2686 | NULL | | 250-86-3243 | Gail | NULL | Sacker | 1991-11-29 | 1 Thackeray Drive | 91616.00 | 508-50-6186 | NULL | | 252-70-1281 | Yoshi | NULL | Kulver | 1990-03-07 | 1716 Myrtle Lane | 24717.00 | 484-58-1616 | NULL | | 259-67-9909 | Tanitansy | NULL | Fragino | 1957-01-28 | 17 Milwaukee Alley | 105180.00 | 622-30-0735 | NULL | | 259-69-3521 | Huey | NULL | Hertwell | 1948-05-27 | 0 Linden Alley | 16424.00 | 874-24-1805 | NULL | | 279-97-0698 | Emilie | NULL | MacGahey | 1936-06-26 | 22 Shoshone Lane | 116060.00 | 301-24-1567 | NULL | | 301-24-1567 | Haydon | NULL | Kimmel | 1963-06-13 | 62 Ohio Avenue | 72145.00 | 467-54-3176 | NULL | | 310-24-7033 | Garrick | NULL | Greaves | 1952-07-24 | 416 Bowman Lane | 42650.00 | 279-97-0698 | NULL | | 311-57-2543 | Darnell | NULL | Prosek | 1978-04-11 | 63 Clarendon Junction | 94333.00 | 622-30-0735 | NULL | | 327-45-5907 | Cob | NULL | Tattoo | 1991-01-05 | 5 Village Green Way | 29381.00 | 508-50-6186 | NULL | | 356-90-7571 | Saunder | NULL | Penney | 1981-03-16 | 27299 Lake View Drive | 85364.00 | 301-24-1567 | NULL | | 357-26-8858 | Nissy | NULL | Matteotti | 1903-10-22 | 22 Lakewood Gardens Pass | 72048.00 | 155-65-2686 | NULL | | 368-34-7197 | Angel | NULL | Mathivat | 1995-04-08 | 665 Scoville Trail | 104433.00 | 874-24-1805 | NULL | | 369-50-5680 | Derby | NULL | Twohig | 1942-06-26 | 0 Golden Leaf Circle | 14023.00 | 301-24-1567 | NULL | | 375-34-0891 | Evan | NULL | Fancet | 1919-09-15 | 875 Hovde Alley | 29485.00 | 155-65-2686 | NULL | | 407-66-4296 | Stinky | NULL | Sterke | 1955-02-16 | 64893 Saint Paul Plaza | 13527.00 | 874-24-1805 | NULL | | 414-10-4271 | Gerrie | NULL | Pentony | 1921-03-05 | 931 Bellgrove Alley | 100074.00 | 301-24-1567 | NULL | | 439-93-4732 | Sibby | NULL | Cressor | 1922-09-03 | 92310 Carberry Parkway | 77597.00 | 279-97-0698 | NULL | | 440-89-5164 | Jehu | NULL | Ropking | 1977-03-11 | 963 Kim Road | 83639.00 | 484-58-1616 | NULL | | 442-52-4791 | Cristobal | NULL | Aven | 1958-01-17 | 5174 Sycamore Terrace | 17619.00 | 785-69-1449 | NULL | | 447-39-2466 | Launce | NULL | Bewley | 1981-02-07 | 54802 Kingsford Park | 84652.00 | 874-24-1805 | NULL | | 449-14-0909 | Marcos | NULL | Burr | 1977-06-16 | 8 Schurz Pass | 113462.00 | 484-58-1616 | NULL | | 463-13-5723 | Wylie | NULL | Stanley | 1950-01-16 | 1153 Trailsway Circle | 89016.00 | 484-58-1616 | NULL | | 467-54-3176 | Ora | NULL | Walrond | 1972-07-29 | 8 La Follette Point | 11450.00 | 622-30-0735 | NULL | | 476-67-1971 | Carrie | NULL | Chansonnau | 1917-11-18 | 84 Service Terrace | 115335.00 | 279-97-0698 | NULL | | 484-58-1616 | Pauly | NULL | Bowman | 1969-04-17 | 7444 5th Court | 58473.00 | 508-50-6186 | NULL | | 486-81-9989 | Asher | NULL | Sleney | 1968-02-11 | 1 Bashford Trail | 91245.00 | 622-30-0735 | NULL | | 489-86-9980 | Darlleen | NULL | Juckes | 1949-06-07 | 26981 6th Way | 81692.00 | 301-24-1567 | NULL | | 508-50-6186 | Hillary | NULL | Leathers | 1903-09-22 | 79 Independence Hill | 84218.00 | 467-54-3176 | NULL | | 515-40-9765 | Quillan | NULL | Fenge | 1949-09-11 | 9 Spaight Place | 79702.00 | 301-24-1567 | NULL | | 519-28-6669 | Kyla | NULL | Corwin | 1972-05-13 | 97 David Road | 21637.00 | 279-97-0698 | NULL | | 521-40-4757 | Arri | NULL | Bye | 1931-10-19 | 7 Sauthoff Terrace | 29068.00 | 874-24-1805 | NULL | | 521-52-7799 | Kelley | NULL | Jaher | 1913-06-29 | 869 Iowa Drive | 68023.00 | 301-24-1567 | NULL | | 526-92-5991 | Carita | NULL | Grievson | 1947-11-05 | 1 Grim Terrace | 107154.00 | 327-45-5907 | NULL | | 532-76-3517 | Rozalin | NULL | Chilcotte | 1990-12-15 | 5513 Birchwood Way | 113445.00 | 467-54-3176 | NULL | | 533-85-8477 | Winthrop | NULL | Whitrod | 1997-04-25 | 84759 Pankratz Hill | 56117.00 | 508-50-6186 | NULL | | 536-16-5537 | Vladimir | NULL | Hayller | 1944-08-25 | 90276 5th Crossing | 45153.00 | 301-24-1567 | NULL | | 543-29-8929 | Shawn | NULL | Clell | 1910-07-09 | 45225 Algoma Alley | 28033.00 | 874-24-1805 | NULL | | 548-58-9075 | Lincoln | NULL | Dimitriev | 1926-03-16 | 522 Evergreen Pass | 111873.00 | 279-97-0698 | NULL | | 554-96-0793 | Modesty | NULL | Tattoo | 1944-11-05 | 56790 Muir Park | 98339.00 | 467-54-3176 | NULL | | 575-99-3134 | June | NULL | De Gouy | 1901-10-08 | 43890 Mccormick Center | 28310.00 | 622-30-0735 | NULL | | 575-99-5872 | Dennie | NULL | Deeney | 1928-08-28 | 552 Lunder Avenue | 31020.00 | 467-54-3176 | NULL | | 581-28-8564 | Bernie | NULL | Neggrini | 1912-03-04 | 5 Scott Circle | 90706.00 | 874-24-1805 | NULL | | 596-37-9209 | Jilli | NULL | Moan | 1972-11-22 | 40 Kim Court | 80743.00 | 785-69-1449 | NULL | | 600-82-6063 | Gates | NULL | Jacobowits | 1927-09-17 | 0 Eggendart Junction | 64355.00 | 874-24-1805 | NULL | | 608-12-4879 | Kiersten | NULL | Pechan | 1948-12-29 | 91412 Debs Way | 26981.00 | 301-24-1567 | NULL | | 609-89-7019 | Darelle | NULL | Colls | 1950-04-21 | 79957 Paget Hill | 53247.00 | 301-24-1567 | NULL | | 615-18-6818 | Janean | NULL | Azam | 1914-10-14 | 83 Upham Drive | 26517.00 | 508-50-6186 | NULL | | 622-30-0735 | Katine | NULL | Staff | 1911-06-22 | 00 Steensland Junction | 28688.00 | 155-65-2686 | NULL | | 626-86-0981 | Hadley | NULL | Wallbutton | 1971-01-13 | 55 Elka Street | 55988.00 | 279-97-0698 | NULL | | 632-84-2428 | Kiele | NULL | Boorne | 1923-10-04 | 06 Cascade Way | 111467.00 | 301-24-1567 | NULL | | 640-78-3450 | Berkley | NULL | Jozwicki | 1934-02-24 | 880 Carey Drive | 56747.00 | 508-50-6186 | NULL | | 645-74-0526 | Rodolphe | NULL | Bartolomieu | 1976-09-07 | 0326 Bultman Park | 13946.00 | 279-97-0698 | NULL | | 645-89-3504 | Berny | NULL | Paragreen | 1971-06-15 | 82676 Old Shore Alley | 52840.00 | 785-69-1449 | NULL | | 649-68-0970 | Parke | NULL | Commins | 1962-08-24 | 7 Starling Point | 83247.00 | 622-30-0735 | NULL | | 658-02-8079 | Baryram | NULL | Duny | 1984-04-08 | 779 Lighthouse Bay Trail | 64044.00 | 622-30-0735 | NULL | | 663-54-0337 | Gradeigh | NULL | Starbucke | 1987-08-01 | 14 Oakridge Road | 114335.00 | 874-24-1805 | NULL | | 665-86-8548 | Vanni | NULL | Shorey | 1951-10-20 | 83068 Golf Course Hill | 87252.00 | 785-69-1449 | NULL | | 676-04-3191 | Dimitri | NULL | Carter | 1943-09-02 | 2 Artisan Plaza | 24445.00 | 155-65-2686 | NULL | | 688-21-1512 | Christabella | NULL | Shambrook | 1927-08-22 | 5 Huxley Park | 97957.00 | 484-58-1616 | NULL | | 717-85-9172 | Ted | NULL | Peterson | 1983-04-05 | 491 Ronald Regan Hill | 104690.00 | 785-69-1449 | NULL | | 720-58-9192 | Lacie | NULL | Woodyeare | 1945-07-12 | 6 Farwell Street | 58790.00 | 484-58-1616 | NULL | | 725-13-9144 | Banky | NULL | Wright | 1907-10-14 | 40598 Center Drive | 23840.00 | 622-30-0735 | NULL | | 730-73-1824 | Allyn | NULL | Peplay | 1982-06-05 | 2673 South Crossing | 59104.00 | 279-97-0698 | NULL | | 735-36-0902 | Duky | NULL | Masser | 1972-07-23 | 01257 Florence Plaza | 45282.00 | 327-45-5907 | NULL | | 740-55-0204 | Ty | NULL | Outibridge | 1983-11-09 | 0892 Aberg Street | 108147.00 | 785-69-1449 | NULL | | 755-49-5779 | Esther | NULL | Martinetto | 1901-03-10 | 34 Marquette Lane | 88225.00 | 155-65-2686 | NULL | | 769-08-1237 | Willie | NULL | Wakeley | 1991-05-31 | 30 Clemons Parkway | 110699.00 | 327-45-5907 | NULL | | 785-69-1449 | Berthe | NULL | Pasfield | 1914-02-23 | 8880 Granby Trail | 42197.00 | 467-54-3176 | NULL | | 788-79-8433 | Abbey | NULL | Scurman | 1951-08-18 | 2 Schurz Court | 23091.00 | 484-58-1616 | NULL | | 799-59-0118 | Raff | NULL | Dymond | 1921-11-02 | 008 Hanson Pass | 67151.00 | 327-45-5907 | NULL | | 801-55-5158 | Durward | NULL | O' Lone | 1983-07-23 | 08795 Gale Place | 67804.00 | 155-65-2686 | NULL | | 803-13-5063 | Basil | NULL | Borkett | 1914-03-14 | 9 Autumn Leaf Circle | 95558.00 | 622-30-0735 | NULL | | 827-84-9853 | Brietta | NULL | McKie | 1985-01-23 | 17 Lindbergh Parkway | 95141.00 | 279-97-0698 | NULL | | 829-82-9898 | Lawry | NULL | Elsom | 1937-03-31 | 8 Nobel Hill | 30624.00 | 785-69-1449 | NULL | | 831-68-7820 | Job | NULL | Wadforth | 1973-07-26 | 57 Nobel Plaza | 75210.00 | 874-24-1805 | NULL | | 850-85-0292 | Constanta | NULL | Spindler | 1943-10-30 | 88 Harbort Lane | 61190.00 | 484-58-1616 | NULL | | 851-37-9880 | Aggie | NULL | Pruvost | 1959-06-07 | 750 Mayfield Plaza | 60655.00 | 484-58-1616 | NULL | | 852-63-0193 | Phil | NULL | Gabbott | 1955-08-30 | 22663 Sunfield Court | 106334.00 | 508-50-6186 | NULL | | 855-68-5051 | Guinna | NULL | Bennoe | 1904-12-22 | 8 Dixon Road | 45806.00 | 622-30-0735 | NULL | | 861-96-0479 | Jody | NULL | Purcell | 1943-02-18 | 8 Lawn Center | 80966.00 | 155-65-2686 | NULL | | 862-55-5133 | Adolph | NULL | Lytton | 1937-10-11 | 0 Service Crossing | 28249.00 | 155-65-2686 | NULL | | 874-24-1805 | Granthem | NULL | Tiffin | 1984-05-09 | 6731 Mandrake Drive | 92694.00 | 467-54-3176 | NULL | | 893-15-9265 | Stefan | NULL | Tokley | 1917-07-24 | 74631 8th Place | 106871.00 | 874-24-1805 | NULL | +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-------------+---------+ B100 rows in set (0.001 sec) BB selectDdistinctmSuper_SSNdfromEEmployee;ETySuper_SSN = (select SSN from supervisors order by rand() limit 1); +-------------+ | Super_SSN | +-------------+ | 155-65-2686 | | 279-97-0698 | | 301-24-1567 | | 327-45-5907 | | 467-54-3176 | | 484-58-1616 | | 508-50-6186 | | 622-30-0735 | | 785-69-1449 | | 874-24-1805 | +-------------+ B10 rows in set (0.001 sec) BB BMariaDB [companys23]> source Department.sql BQuery OK, 1 row affected (0.002 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.001 sec) BB ERROR 1406 (22001) at line 4 in file: 'Department.sql': Data too long for column 'Dname' at row 1 BBBBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BMariaDB [companys23]> select * from Departmnet; ERROR 1146 (42S02): Table 'companys23.Departmnet' doesn't exist BBMariaDB [companys23]> select * from Department; +---------+----------------------+---------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+---------+------------+ | 1 | Engineering | NULL | 2021-11-01 | | 2 | Human Resources | NULL | 2004-07-03 | | 3 | Sales | NULL | 2010-12-26 | | 5 | Business Development | NULL | 2016-08-02 | | 6 | Marketing | NULL | 2003-06-19 | +---------+----------------------+---------+------------+ B5 rows in set (0.000 sec) BB BMariaDB [companys23]> delete from Department; BQuery OK, 5 rows affected (0.001 sec) BB BMariaDourcemDepartment.sqlnet;rom Department; BQuery OK, 1 row affected (0.001 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BBQuery OK, 1 row affected (0.000 sec) BB BMariaDB [companys23]> select *romrDepartment; +---------+----------------------+---------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+---------+------------+ | 1 | Engineering | NULL | 2021-11-01 | | 2 | Human Resources | NULL | 2004-07-03 | | 3 | Sales | NULL | 2010-12-26 | | 4 | R&D | NULL | 2005-01-05 | | 5 | Business Development | NULL | 2016-08-02 | | 6 | Marketing | NULL | 2003-06-19 | +---------+----------------------+---------+------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> describe Employee; +-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | SSN | char(11) | NO | PRI | NULL | | | Fname | varchar(20) | NO | | NULL | | | Minit | char(1) | YES | | NULL | | | Lname | varchar(20) | NO | | NULL | | | Bdate | date | YES | | NULL | | | Address | varchar(100) | YES | | NULL | | | Salary | decimal(14,2) | YES | | NULL | | | Super_SSN | char(11) | YES | MUL | NULL | | | Dnumber | int(11) | YES | MUL | NULL | | +-----------+---------------+------+-----+---------+-------+ B9 rows in set (0.001 sec) BB BMariaDB [companys23]> update Employee set Dnumber = (select Dnumber from Department order by rand() limit 1); BQuery OK, 100 rows affected (0.010 sec) BBRows matched: 100 Changed: 100 Warnings: 0 BB BMariaDB [companys23]> select * from Employee; +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-------------+---------+ | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-------------+---------+ | 108-30-6419 | Fredra | NULL | MacIlriach | 1920-04-04 | 43 South Court | 46783.00 | 155-65-2686 | 4 | | 112-77-5572 | Shelby | NULL | Smethurst | 1973-09-29 | 05 Donald Park | 84462.00 | 484-58-1616 | 5 | | 134-43-6596 | Maurine | NULL | Gibbonson | 1927-12-24 | 50253 Haas Hill | 62122.00 | 622-30-0735 | 2 | | 155-65-2686 | Sandi | NULL | Berni | 1910-09-19 | 42355 Fremont Avenue | 74728.00 | 327-45-5907 | 2 | | 157-88-7908 | Anna | NULL | Lissandri | 1972-04-12 | 104 Hagan Pass | 60820.00 | 508-50-6186 | 1 | | 169-88-1613 | Marietta | NULL | Dawidowitz | 1951-03-07 | 17032 Tennessee Crossing | 22283.00 | 484-58-1616 | 1 | | 178-09-9074 | Ella | NULL | Wollard | 1910-07-03 | 2392 Tomscot Alley | 87538.00 | 785-69-1449 | 1 | | 180-68-1912 | Dania | NULL | Felipe | 1996-10-12 | 07274 Cordelia Place | 89565.00 | 327-45-5907 | 1 | | 195-36-4688 | Henri | NULL | Handasyde | 1980-08-30 | 152 1st Street | 43031.00 | 622-30-0735 | 6 | | 199-45-7914 | Tabbatha | NULL | Nelmes | 1984-06-06 | 8 Bayside Terrace | 39556.00 | 622-30-0735 | 4 | | 206-42-6778 | Borg | NULL | Tonks | 1928-12-25 | 2085 International Court | 54754.00 | 467-54-3176 | 2 | | 218-15-2428 | Templeton | NULL | Southerton | 1968-04-09 | 74 Lighthouse Bay Plaza | 16122.00 | 155-65-2686 | 5 | | 221-78-4352 | Abbe | NULL | Halson | 1962-04-14 | 00 Esch Terrace | 49285.00 | 622-30-0735 | 3 | | 224-05-5365 | Walton | NULL | Stolworthy | 1987-06-21 | 6992 Independence Terrace | 102697.00 | 467-54-3176 | 3 | | 248-16-5831 | Melvin | NULL | Cockshut | 1947-06-14 | 56 Union Center | 70895.00 | 785-69-1449 | 6 | | 250-42-9823 | Pierette | NULL | Thyer | 1960-04-03 | 8 Waywood Place | 25267.00 | 467-54-3176 | 5 | | 250-45-6366 | Valina | NULL | Witch | 1916-07-01 | 7 Northland Alley | 107406.00 | 155-65-2686 | 6 | | 250-86-3243 | Gail | NULL | Sacker | 1991-11-29 | 1 Thackeray Drive | 91616.00 | 508-50-6186 | 5 | | 252-70-1281 | Yoshi | NULL | Kulver | 1990-03-07 | 1716 Myrtle Lane | 24717.00 | 484-58-1616 | 1 | | 259-67-9909 | Tanitansy | NULL | Fragino | 1957-01-28 | 17 Milwaukee Alley | 105180.00 | 622-30-0735 | 3 | | 259-69-3521 | Huey | NULL | Hertwell | 1948-05-27 | 0 Linden Alley | 16424.00 | 874-24-1805 | 2 | | 279-97-0698 | Emilie | NULL | MacGahey | 1936-06-26 | 22 Shoshone Lane | 116060.00 | 301-24-1567 | 4 | | 301-24-1567 | Haydon | NULL | Kimmel | 1963-06-13 | 62 Ohio Avenue | 72145.00 | 467-54-3176 | 6 | | 310-24-7033 | Garrick | NULL | Greaves | 1952-07-24 | 416 Bowman Lane | 42650.00 | 279-97-0698 | 6 | | 311-57-2543 | Darnell | NULL | Prosek | 1978-04-11 | 63 Clarendon Junction | 94333.00 | 622-30-0735 | 2 | | 327-45-5907 | Cob | NULL | Tattoo | 1991-01-05 | 5 Village Green Way | 29381.00 | 508-50-6186 | 5 | | 356-90-7571 | Saunder | NULL | Penney | 1981-03-16 | 27299 Lake View Drive | 85364.00 | 301-24-1567 | 1 | | 357-26-8858 | Nissy | NULL | Matteotti | 1903-10-22 | 22 Lakewood Gardens Pass | 72048.00 | 155-65-2686 | 1 | | 368-34-7197 | Angel | NULL | Mathivat | 1995-04-08 | 665 Scoville Trail | 104433.00 | 874-24-1805 | 3 | | 369-50-5680 | Derby | NULL | Twohig | 1942-06-26 | 0 Golden Leaf Circle | 14023.00 | 301-24-1567 | 1 | | 375-34-0891 | Evan | NULL | Fancet | 1919-09-15 | 875 Hovde Alley | 29485.00 | 155-65-2686 | 1 | | 407-66-4296 | Stinky | NULL | Sterke | 1955-02-16 | 64893 Saint Paul Plaza | 13527.00 | 874-24-1805 | 5 | | 414-10-4271 | Gerrie | NULL | Pentony | 1921-03-05 | 931 Bellgrove Alley | 100074.00 | 301-24-1567 | 3 | | 439-93-4732 | Sibby | NULL | Cressor | 1922-09-03 | 92310 Carberry Parkway | 77597.00 | 279-97-0698 | 5 | | 440-89-5164 | Jehu | NULL | Ropking | 1977-03-11 | 963 Kim Road | 83639.00 | 484-58-1616 | 5 | | 442-52-4791 | Cristobal | NULL | Aven | 1958-01-17 | 5174 Sycamore Terrace | 17619.00 | 785-69-1449 | 2 | | 447-39-2466 | Launce | NULL | Bewley | 1981-02-07 | 54802 Kingsford Park | 84652.00 | 874-24-1805 | 6 | | 449-14-0909 | Marcos | NULL | Burr | 1977-06-16 | 8 Schurz Pass | 113462.00 | 484-58-1616 | 6 | | 463-13-5723 | Wylie | NULL | Stanley | 1950-01-16 | 1153 Trailsway Circle | 89016.00 | 484-58-1616 | 3 | | 467-54-3176 | Ora | NULL | Walrond | 1972-07-29 | 8 La Follette Point | 11450.00 | 622-30-0735 | 2 | | 476-67-1971 | Carrie | NULL | Chansonnau | 1917-11-18 | 84 Service Terrace | 115335.00 | 279-97-0698 | 4 | | 484-58-1616 | Pauly | NULL | Bowman | 1969-04-17 | 7444 5th Court | 58473.00 | 508-50-6186 | 6 | | 486-81-9989 | Asher | NULL | Sleney | 1968-02-11 | 1 Bashford Trail | 91245.00 | 622-30-0735 | 1 | | 489-86-9980 | Darlleen | NULL | Juckes | 1949-06-07 | 26981 6th Way | 81692.00 | 301-24-1567 | 4 | | 508-50-6186 | Hillary | NULL | Leathers | 1903-09-22 | 79 Independence Hill | 84218.00 | 467-54-3176 | 6 | | 515-40-9765 | Quillan | NULL | Fenge | 1949-09-11 | 9 Spaight Place | 79702.00 | 301-24-1567 | 6 | | 519-28-6669 | Kyla | NULL | Corwin | 1972-05-13 | 97 David Road | 21637.00 | 279-97-0698 | 4 | | 521-40-4757 | Arri | NULL | Bye | 1931-10-19 | 7 Sauthoff Terrace | 29068.00 | 874-24-1805 | 4 | | 521-52-7799 | Kelley | NULL | Jaher | 1913-06-29 | 869 Iowa Drive | 68023.00 | 301-24-1567 | 3 | | 526-92-5991 | Carita | NULL | Grievson | 1947-11-05 | 1 Grim Terrace | 107154.00 | 327-45-5907 | 1 | | 532-76-3517 | Rozalin | NULL | Chilcotte | 1990-12-15 | 5513 Birchwood Way | 113445.00 | 467-54-3176 | 1 | | 533-85-8477 | Winthrop | NULL | Whitrod | 1997-04-25 | 84759 Pankratz Hill | 56117.00 | 508-50-6186 | 2 | | 536-16-5537 | Vladimir | NULL | Hayller | 1944-08-25 | 90276 5th Crossing | 45153.00 | 301-24-1567 | 1 | | 543-29-8929 | Shawn | NULL | Clell | 1910-07-09 | 45225 Algoma Alley | 28033.00 | 874-24-1805 | 1 | | 548-58-9075 | Lincoln | NULL | Dimitriev | 1926-03-16 | 522 Evergreen Pass | 111873.00 | 279-97-0698 | 4 | | 554-96-0793 | Modesty | NULL | Tattoo | 1944-11-05 | 56790 Muir Park | 98339.00 | 467-54-3176 | 6 | | 575-99-3134 | June | NULL | De Gouy | 1901-10-08 | 43890 Mccormick Center | 28310.00 | 622-30-0735 | 3 | | 575-99-5872 | Dennie | NULL | Deeney | 1928-08-28 | 552 Lunder Avenue | 31020.00 | 467-54-3176 | 6 | | 581-28-8564 | Bernie | NULL | Neggrini | 1912-03-04 | 5 Scott Circle | 90706.00 | 874-24-1805 | 2 | | 596-37-9209 | Jilli | NULL | Moan | 1972-11-22 | 40 Kim Court | 80743.00 | 785-69-1449 | 1 | | 600-82-6063 | Gates | NULL | Jacobowits | 1927-09-17 | 0 Eggendart Junction | 64355.00 | 874-24-1805 | 6 | | 608-12-4879 | Kiersten | NULL | Pechan | 1948-12-29 | 91412 Debs Way | 26981.00 | 301-24-1567 | 4 | | 609-89-7019 | Darelle | NULL | Colls | 1950-04-21 | 79957 Paget Hill | 53247.00 | 301-24-1567 | 6 | | 615-18-6818 | Janean | NULL | Azam | 1914-10-14 | 83 Upham Drive | 26517.00 | 508-50-6186 | 1 | | 622-30-0735 | Katine | NULL | Staff | 1911-06-22 | 00 Steensland Junction | 28688.00 | 155-65-2686 | 1 | | 626-86-0981 | Hadley | NULL | Wallbutton | 1971-01-13 | 55 Elka Street | 55988.00 | 279-97-0698 | 4 | | 632-84-2428 | Kiele | NULL | Boorne | 1923-10-04 | 06 Cascade Way | 111467.00 | 301-24-1567 | 3 | | 640-78-3450 | Berkley | NULL | Jozwicki | 1934-02-24 | 880 Carey Drive | 56747.00 | 508-50-6186 | 4 | | 645-74-0526 | Rodolphe | NULL | Bartolomieu | 1976-09-07 | 0326 Bultman Park | 13946.00 | 279-97-0698 | 1 | | 645-89-3504 | Berny | NULL | Paragreen | 1971-06-15 | 82676 Old Shore Alley | 52840.00 | 785-69-1449 | 5 | | 649-68-0970 | Parke | NULL | Commins | 1962-08-24 | 7 Starling Point | 83247.00 | 622-30-0735 | 5 | | 658-02-8079 | Baryram | NULL | Duny | 1984-04-08 | 779 Lighthouse Bay Trail | 64044.00 | 622-30-0735 | 4 | | 663-54-0337 | Gradeigh | NULL | Starbucke | 1987-08-01 | 14 Oakridge Road | 114335.00 | 874-24-1805 | 3 | | 665-86-8548 | Vanni | NULL | Shorey | 1951-10-20 | 83068 Golf Course Hill | 87252.00 | 785-69-1449 | 1 | | 676-04-3191 | Dimitri | NULL | Carter | 1943-09-02 | 2 Artisan Plaza | 24445.00 | 155-65-2686 | 6 | | 688-21-1512 | Christabella | NULL | Shambrook | 1927-08-22 | 5 Huxley Park | 97957.00 | 484-58-1616 | 2 | | 717-85-9172 | Ted | NULL | Peterson | 1983-04-05 | 491 Ronald Regan Hill | 104690.00 | 785-69-1449 | 3 | | 720-58-9192 | Lacie | NULL | Woodyeare | 1945-07-12 | 6 Farwell Street | 58790.00 | 484-58-1616 | 5 | | 725-13-9144 | Banky | NULL | Wright | 1907-10-14 | 40598 Center Drive | 23840.00 | 622-30-0735 | 3 | | 730-73-1824 | Allyn | NULL | Peplay | 1982-06-05 | 2673 South Crossing | 59104.00 | 279-97-0698 | 4 | | 735-36-0902 | Duky | NULL | Masser | 1972-07-23 | 01257 Florence Plaza | 45282.00 | 327-45-5907 | 4 | | 740-55-0204 | Ty | NULL | Outibridge | 1983-11-09 | 0892 Aberg Street | 108147.00 | 785-69-1449 | 4 | | 755-49-5779 | Esther | NULL | Martinetto | 1901-03-10 | 34 Marquette Lane | 88225.00 | 155-65-2686 | 6 | | 769-08-1237 | Willie | NULL | Wakeley | 1991-05-31 | 30 Clemons Parkway | 110699.00 | 327-45-5907 | 3 | | 785-69-1449 | Berthe | NULL | Pasfield | 1914-02-23 | 8880 Granby Trail | 42197.00 | 467-54-3176 | 2 | | 788-79-8433 | Abbey | NULL | Scurman | 1951-08-18 | 2 Schurz Court | 23091.00 | 484-58-1616 | 4 | | 799-59-0118 | Raff | NULL | Dymond | 1921-11-02 | 008 Hanson Pass | 67151.00 | 327-45-5907 | 5 | | 801-55-5158 | Durward | NULL | O' Lone | 1983-07-23 | 08795 Gale Place | 67804.00 | 155-65-2686 | 3 | | 803-13-5063 | Basil | NULL | Borkett | 1914-03-14 | 9 Autumn Leaf Circle | 95558.00 | 622-30-0735 | 2 | | 827-84-9853 | Brietta | NULL | McKie | 1985-01-23 | 17 Lindbergh Parkway | 95141.00 | 279-97-0698 | 3 | | 829-82-9898 | Lawry | NULL | Elsom | 1937-03-31 | 8 Nobel Hill | 30624.00 | 785-69-1449 | 3 | | 831-68-7820 | Job | NULL | Wadforth | 1973-07-26 | 57 Nobel Plaza | 75210.00 | 874-24-1805 | 3 | | 850-85-0292 | Constanta | NULL | Spindler | 1943-10-30 | 88 Harbort Lane | 61190.00 | 484-58-1616 | 1 | | 851-37-9880 | Aggie | NULL | Pruvost | 1959-06-07 | 750 Mayfield Plaza | 60655.00 | 484-58-1616 | 2 | | 852-63-0193 | Phil | NULL | Gabbott | 1955-08-30 | 22663 Sunfield Court | 106334.00 | 508-50-6186 | 4 | | 855-68-5051 | Guinna | NULL | Bennoe | 1904-12-22 | 8 Dixon Road | 45806.00 | 622-30-0735 | 1 | | 861-96-0479 | Jody | NULL | Purcell | 1943-02-18 | 8 Lawn Center | 80966.00 | 155-65-2686 | 3 | | 862-55-5133 | Adolph | NULL | Lytton | 1937-10-11 | 0 Service Crossing | 28249.00 | 155-65-2686 | 6 | | 874-24-1805 | Granthem | NULL | Tiffin | 1984-05-09 | 6731 Mandrake Drive | 92694.00 | 467-54-3176 | 6 | | 893-15-9265 | Stefan | NULL | Tokley | 1917-07-24 | 74631 8th Place | 106871.00 | 874-24-1805 | 6 | +-------------+--------------+-------+-------------+------------+---------------------------+-----------+-------------+---------+ B100 rows in set (0.001 sec) BB BMariaDB [companys23]> select Dnumber, count(*) from Employee group by Dnumber; +---------+----------+ | Dnumber | count(*) | +---------+----------+ | 1 | 21 | | 2 | 13 | | 3 | 18 | | 4 | 17 | | 5 | 12 | | 6 | 19 | +---------+----------+ B6 rows in set (0.001 sec) BB BMariaDB [companys23]> create temporary table managers as select SSN from Employee order by rand() limit 6;; BQuery OK, 6 rows affected (0.001 sec) BBRecords: 6 Duplicates: 0 Warnings: 0 BB BMariaDB [companys23]> select * from managers; +-------------+ | SSN | +-------------+ | 250-42-9823 | | 252-70-1281 | | 626-86-0981 | | 521-40-4757 | | 259-69-3521 | | 218-15-2428 | +-------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> describeeDepartment;t Mgr_SSN = +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | Dnumber | int(11) | NO | PRI | NULL | auto_increment | | Dname | varchar(20) | YES | UNI | NULL | | | Mgr_SSN | char(11) | YES | MUL | NULL | | | Mgr_start | date | YES | | NULL | | +-----------+-------------+------+-----+---------+----------------+ B4 rows in set (0.001 sec) BB BMariaDB [companys23]> update Department set Mgr_SSN = (select SSN from managers order by rand() limit 1); BQuery OK, 6 rows affected (0.003 sec) BBRows matched: 6 Changed: 6 Warnings: 0 BB describe Department;]> update Department set Mgr_SSN = (select SSN from managers order by rand() limit 1); +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | Dnumber | int(11) | NO | PRI | NULL | auto_increment | | Dname | varchar(20) | YES | UNI | NULL | | | Mgr_SSN | char(11) | YES | MUL | NULL | | | Mgr_start | date | YES | | NULL | | +-----------+-------------+------+-----+---------+----------------+ B4 rows in set (0.001 sec) BB BMariaDB [companys23]> select * from Department;; +---------+----------------------+-------------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+-------------+------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | | 2 | Human Resources | 250-42-9823 | 2004-07-03 | | 3 | Sales | 250-42-9823 | 2010-12-26 | | 4 | R&D | 218-15-2428 | 2005-01-05 | | 5 | Business Development | 250-42-9823 | 2016-08-02 | | 6 | Marketing | 259-69-3521 | 2003-06-19 | +---------+----------------------+-------------+------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> update Departmetn set Mgr_SSN = NULL; ERROR 1146 (42S02): Table 'companys23.Departmetn' doesn't exist BBMariaDB [companys23]> update Department set Mgr_SSN = NULL; BQuery OK, 6 rows affected (0.003 sec) BBRows matched: 6 Changed: 6 Warnings: 0 BB BMariaDB [companys23]> select * from Department; +---------+----------------------+---------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+---------+------------+ | 1 | Engineering | NULL | 2021-11-01 | | 2 | Human Resources | NULL | 2004-07-03 | | 3 | Sales | NULL | 2010-12-26 | | 4 | R&D | NULL | 2005-01-05 | | 5 | Business Development | NULL | 2016-08-02 | | 6 | Marketing | NULL | 2003-06-19 | +---------+----------------------+---------+------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> update Department set Mgr_SSN = (select SSN from managers limit 1) where Dnumber = 1; BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB selectD* frompDepartment;date Department set Mgr_SSN = (select SSN from managers limit 1) where Dnumber = 1; +---------+----------------------+-------------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+-------------+------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | | 2 | Human Resources | NULL | 2004-07-03 | | 3 | Sales | NULL | 2010-12-26 | | 4 | R&D | NULL | 2005-01-05 | | 5 | Business Development | NULL | 2016-08-02 | | 6 | Marketing | NULL | 2003-06-19 | +---------+----------------------+-------------+------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> delete fromomanagersmwhere SSN in (select Mgr_SSN from Department); BQuery OK, 1 row affected (0.001 sec) BB updateDDepartmentaseteMgr_SSN =r(selectgSSN fromemanagers(limitt1)gwhere Dnumberp=r2;ent); BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB deleteDfromomanagers]whereaSSNDina(selectsMgr_SSNSfrom Department);from managers limit 1) where Dnumber = 2; BQuery OK, 1 row affected (0.001 sec) BB updateDDepartmentsset>Mgr_SSN =r(selectgSSN fromemanagers(limitt1)gwhere Dnumberp=r3;ent); BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB deleteDfromomanagers]whereaSSNDina(selectsMgr_SSNSfrom Department);from managers limit 1) where Dnumber = 3; BQuery OK, 1 row affected (0.001 sec) BB updateDDepartmentsset>Mgr_SSN =r(selectgSSN fromemanagers(limitt1)gwhere Dnumberp=r4;ent); BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB deleteDfromomanagers]whereaSSNDina(selectsMgr_SSNSfrom Department);from managers limit 1) where Dnumber = 4; BQuery OK, 1 row affected (0.001 sec) BB updateDDepartmentsset>Mgr_SSN =r(selectgSSN fromemanagers(limitt1)gwhere Dnumberp=r5;ent); BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB deleteDfromomanagers]whereaSSNDina(selectsMgr_SSNSfrom Department);from managers limit 1) where Dnumber = 5; BQuery OK, 1 row affected (0.001 sec) BB updateDDepartmentsset>Mgr_SSN =r(selectgSSN fromemanagers(limitt1)gwhere Dnumberp=r6;ent); BQuery OK, 1 row affected (0.001 sec) BBRows matched: 1 Changed: 1 Warnings: 0 BB deleteDfromomanagers]whereaSSNDina(selectsMgr_SSNSfrom Department);from managers limit 1) where Dnumber = 6; BQuery OK, 1 row affected (0.001 sec) BB BMariaDB [companys23]> select * from Department; +---------+----------------------+-------------+------------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | +---------+----------------------+-------------+------------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | | 3 | Sales | 626-86-0981 | 2010-12-26 | | 4 | R&D | 521-40-4757 | 2005-01-05 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | +---------+----------------------+-------------+------------+ B6 rows in set (0.000 sec) BB BMariaDB [companys23]> select * from Department inner join Employee ON SSN = Mgr_SSN; +---------+----------------------+-------------+------------+-------------+-----------+-------+------------+------------+-------------------------+----------+-------------+---------+ | Dnumber | Dname | Mgr_SSN | Mgr_start | SSN | Fname | Minit | Lname | Bdate | Address | Salary | Super_SSN | Dnumber | +---------+----------------------+-------------+------------+-------------+-----------+-------+------------+------------+-------------------------+----------+-------------+---------+ | 1 | Engineering | 250-42-9823 | 2021-11-01 | 250-42-9823 | Pierette | NULL | Thyer | 1960-04-03 | 8 Waywood Place | 25267.00 | 467-54-3176 | 5 | | 2 | Human Resources | 252-70-1281 | 2004-07-03 | 252-70-1281 | Yoshi | NULL | Kulver | 1990-03-07 | 1716 Myrtle Lane | 24717.00 | 484-58-1616 | 1 | | 3 | Sales | 626-86-0981 | 2010-12-26 | 626-86-0981 | Hadley | NULL | Wallbutton | 1971-01-13 | 55 Elka Street | 55988.00 | 279-97-0698 | 4 | | 4 | R&D | 521-40-4757 | 2005-01-05 | 521-40-4757 | Arri | NULL | Bye | 1931-10-19 | 7 Sauthoff Terrace | 29068.00 | 874-24-1805 | 4 | | 5 | Business Development | 259-69-3521 | 2016-08-02 | 259-69-3521 | Huey | NULL | Hertwell | 1948-05-27 | 0 Linden Alley | 16424.00 | 874-24-1805 | 2 | | 6 | Marketing | 218-15-2428 | 2003-06-19 | 218-15-2428 | Templeton | NULL | Southerton | 1968-04-09 | 74 Lighthouse Bay Plaza | 16122.00 | 155-65-2686 | 5 | +---------+----------------------+-------------+------------+-------------+-----------+-------+------------+------------+-------------------------+----------+-------------+---------+ B6 rows in set (0.001 sec) BB BMariaDB [companys23]> select Fname,Lname,Dname inner join Employee ON SSN = Mgr_SSN; +-----------+------------+----------------------+ | Fname | Lname | Dname | +-----------+------------+----------------------+ | Pierette | Thyer | Engineering | | Yoshi | Kulver | Human Resources | | Hadley | Wallbutton | Sales | | Arri | Bye | R&D | | Huey | Hertwell | Business Development | | Templeton | Southerton | Marketing | +-----------+------------+----------------------+ B6 rows in set (0.001 sec) BB BMariaDB [companys23]> exit BBye Bnick@artemis:~/3420/company/s23$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit