Media Arts and Technology

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.

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 :
Here are the output CSVs for my queries:

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()

In this weeks report, I use commands about JSON operations, bit operations, String functions to find out some interesting titles and some numerical patterns.

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.