I see you have some good responses so far, but that won't stop me from throwing in mine as well. :-)
I am quite goal oriented, so I would appreciate some moderately hard things to accomplish. From there, the sky's the limit. Here are some you can try. 1) Attempt to enter the MySQL application from the command line. That is open a terminal and run MySQL. Sound easy? Ha. Hint: you will need to figure out how to enter user names and passwords 2) Once you succeed in getting a mysql> prompt, enter a command (like, "select dateTime, outTemp from archive limit 1;"). 3) Now try to do this from the command line, like you would from a script. After that, do the same thing but placing your credentials in a config file so it isn't shown on the command line. 4) Now for something a little different, install MySQL Workbench, a GUI interface. Once you can connect to that, you can run interactive queries to learn the SQL language. 5) Once you have some queries, create a script that you can run to give you useful information. Like, the high temperatures for the past week, or the rainfall for the past week. You know, apply what you have learned to something "practical". MySQL really has two things to learn. You need to learn how to access it and you need to learn the language. Access can be really frustrating when all you want to do is learn the language, but it is vital. Then, once you start learning the language you will go from brute force queries to increasingly elegant solutions. You won't be happy seeing dates as numbers, you will want to see actual dates. You might want to do a cumulative rain by day query for a year, and find there is an elegant way to do that. Good luck! Dave On Saturday, September 15, 2018 at 9:09:10 AM UTC-5, John Clark wrote: > > I realize that this is a bit off topic, but having never even worried > about MySQL or SQL Lite before I encountered Weewx, I never felt the need > for learning it. However, having recently > > 1. Retired, so I have time, and > > 2. realized it probably would be a good thing to learn because it might > help in some projects I am working on > > What and where is a good starting point for an absolute MySQL noob? > -- > *John Clark <javascript:>* > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
