wk7 - 11.8.22 4 MySQL commands new to you

Post Reply
glegrady
Posts: 203
Joined: Wed Sep 22, 2010 12:26 pm

wk7 - 11.8.22 4 MySQL commands new to you

Post by glegrady » Fri Sep 16, 2022 7:59 am

11.8.22 4 MySQL commands new to you

For this week's assignment, explore 4 MySQL commands new to you. They can be in combination, or separate. Go through the w3 list of commands and see if you have yet to use any: https://www.w3schools.com/mysql/

The MySQL Reference Manual has a lot of information, unfortunately the manual is so dense it is hard to find things.

Here is a page on "aggregate functions" https://dev.mysql.com/doc/refman/8.0/en ... tions.html

The page on date and time functions: https://dev.mysql.com/doc/refman/8.0/en ... tions.html

The page on string functions: https://dev.mysql.com/doc/refman/8.0/en ... tions.html

Review the EXPLAIN statement to understand how MySQL executes statements: https://dev.mysql.com/doc/refman/8.0/en ... utput.html

In addition to getting experienece with the new commands, the intent is also to see if the commands might reveal some perspectives about the data we are working with.
--
Post your results here. I am traveling to a conference, so we will need to set up individual meetings times. I will be 9 hours ahead so the earlier your time, the better for me.
George Legrady
legrady@mat.ucsb.edu

briannagriffin
Posts: 11
Joined: Fri Sep 23, 2022 10:04 am

Re: wk7 - 11.8.22 4 MySQL commands new to you

Post by briannagriffin » Mon Nov 07, 2022 4:40 pm

For this week’s assignment, I utilized the course data base and SPL data to experiment and teach myself new MySQL functions and commands. I was able to learn new aggregate, time, and string functions that furthered my knowledge of the SQL programming language while discovering new findings within the database. Specifically, I used SQL to query for key statistics, times of specific check outs, and characters of title's for distinct items.

Here is the pdf including my queries and descriptions :
Week 7 - New SQL Commands.pdf
(188.8 KiB) Downloaded 56 times

Here are the output CSVs for my queries:
aggregate_query1.csv
(59 Bytes) Downloaded 49 times
checkout_times_2months_ago.csv
(3.56 KiB) Downloaded 46 times
sounds_like_car.csv
(1.4 KiB) Downloaded 42 times
items_beginning_each_letter.csv
(226 Bytes) Downloaded 44 times
Last edited by briannagriffin on Tue Nov 08, 2022 10:59 am, edited 1 time in total.

ilianikiforov
Posts: 8
Joined: Tue Oct 04, 2022 10:24 am

Re: wk7 - 11.8.22 4 MySQL commands new to you

Post by ilianikiforov » Mon Nov 07, 2022 10:55 pm

In this report, I explore new MySQL functions. Specifically, I try string manipulation, extracting day of the week, getting variance and standard deviation, and manually replacing null values using coalesce()
Attachments
sd_and_var.csv
(63 Bytes) Downloaded 47 times
dayname.csv
(122 Bytes) Downloaded 46 times
concat_and_left.csv
(597 Bytes) Downloaded 40 times
coalesce.csv
(531 Bytes) Downloaded 45 times
Assignment5.pdf
(141.12 KiB) Downloaded 47 times

shaokang
Posts: 8
Joined: Fri Sep 23, 2022 10:07 am

Re: wk7 - 11.8.22 4 MySQL commands new to you

Post by shaokang » Mon Nov 07, 2022 11:36 pm

In this weeks report, I use commands about JSON operations, bit operations, String functions to find out some interesting titles and some numerical patterns.
week07_01.csv
(20 Bytes) Downloaded 54 times
week07_02.csv
(922 Bytes) Downloaded 46 times
week07_03.csv
(93.78 KiB) Downloaded 49 times
week07_04.csv
(23.29 KiB) Downloaded 42 times
Week 07 New SQL Commands.pdf
(266.61 KiB) Downloaded 54 times

nataliadubon
Posts: 15
Joined: Tue Mar 29, 2022 3:30 pm

Re: wk7 - 11.8.22 4 MySQL commands new to you

Post by nataliadubon » Tue Nov 08, 2022 5:31 am

This week’s assignment calls for us to test out new query functions that we may have not used or explored before. After researching the links provided as well as doing my own research, I have gathered the following queries that allow me to truly check out the scope of the functions available in SQL and seeing which ones I can apply for future or past projects. I explore time, case, string, and REGEXP functions.
Attachments
Week 7_ Trying Out New SQL Functions.pdf
(205.28 KiB) Downloaded 50 times

Post Reply