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.
wk7 - 11.8.22 4 MySQL commands new to you
wk7 - 11.8.22 4 MySQL commands new to you
George Legrady
legrady@mat.ucsb.edu
legrady@mat.ucsb.edu
-
- Posts: 11
- Joined: Fri Sep 23, 2022 10:04 am
Re: wk7 - 11.8.22 4 MySQL commands new to you
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:
Here is the pdf including my queries and descriptions :
Here are the output CSVs for my queries:
Last edited by briannagriffin on Tue Nov 08, 2022 10:59 am, edited 1 time in total.
-
- Posts: 8
- Joined: Tue Oct 04, 2022 10:24 am
Re: wk7 - 11.8.22 4 MySQL commands new to you
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 96 times
-
- dayname.csv
- (122 Bytes) Downloaded 98 times
-
- concat_and_left.csv
- (597 Bytes) Downloaded 86 times
-
- coalesce.csv
- (531 Bytes) Downloaded 94 times
-
- Assignment5.pdf
- (141.12 KiB) Downloaded 95 times
Re: wk7 - 11.8.22 4 MySQL commands new to you
In this weeks report, I use commands about JSON operations, bit operations, String functions to find out some interesting titles and some numerical patterns.
-
- Posts: 15
- Joined: Tue Mar 29, 2022 3:30 pm
Re: wk7 - 11.8.22 4 MySQL commands new to you
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 88 times