wk7 - 11.8.22 4 MySQL commands new to you
Posted: 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.
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.