/build/static/layout/Breadcrumb_cap_w.png

Looking for some good mySQL information.

Since becoming the KACE "go to" guy its become painfully obvious that I need to add some mySQL skills to the inventory. While it is great to post and have it answered, at some point I would like to be answering the questions instead of posting them. (In time padawan) Anyway suggestions for (recommended) links, resouces and training would be appreciated.  The company even "offered" training......might have to take them up on that one.

Yes John I have read your blog....twice

Thanx

Jim


0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
http://www.w3schools.com/sql/default.asp http://dev.mysql.com/tech-resources/ http://mysqlresources.com/tutorials http://www.mysqltutorial.org/mysql-resources.aspx http://www.tutorialspoint.com/mysql/index.htm http://www.itninja.com/blog/view/k1000-reports-advanced-mysql-query-techniques-parsing-multiple-substrings-from-a-field-using-temporary-tables http://www.itninja.com/blog/view/k1000-reports-querying-and-reporting-on-network-printer-error-and-status-codes http://www.itninja.com/blog/view/k1000-custom-ticket-rules-using-an-inline-view-to-query-update-tables-in-one-pass http://www.itninja.com/blog/view/k1000-custom-ticket-rules-closing-parent-tickets-automatically-when-all-child-tickets-are-closed
Posted by: dugullett 9 years ago
Red Belt
2

Along with John's post this helped me http://www.w3schools.com/sql/default.asp 

Along with a lot of trial and error. Download the workbench and take a look at it. I would recommend adding a LIMIT 5 to the end of your queries you are unsure of. This will limit the results. I've had some that have brought my Kbox down. 


Comments:
  • Also when someone asks a reporting question on here see if you can do it on your own Kbox. That's where I learned the most. - dugullett 9 years ago
  • Yea, familiar with the trial and mostly error part. Any particular version of workbench? - gargone 9 years ago
    • I'm using 5.2.47 right now. Which I believe is still the latest. I like this version because if you do have a typo/error it will actually underline it in RED. If anything get it as far as you can, and then post your query here. A lot of times others can explain why it's not getting the results you want.

      One thing John did share is that Google searches start everything with MYSQL + <task you need>. That usually gets some good results. - dugullett 9 years ago
  • Just downloaded it. working on getting it connected to the K1. - gargone 9 years ago
    • In case you need it: http://www.kace.com/support/resources/kb/article/can-i-access-the-k1000-appliance-database-using - jknox 9 years ago
  • Got it...and thanx. - gargone 9 years ago
  • Note about W3schools. They're great MOST of the time, but be warned that they have also been shown to have incorrect information, and are in no way affiliated with the actual W3C.

    But for most things W3schools is a great tool to learn MySQL & several web languages.

    See http://w3fools.com/ - Ultimation 9 years ago
Posted by: jdornan 9 years ago
Red Belt
1

Here are a few good ones.

http://dev.mysql.com/tech-resources/
http://mysqlresources.com/tutorials
http://www.mysqltutorial.org/mysql-resources.aspx
http://www.tutorialspoint.com/mysql/index.htm 


Comments:
  • Thank you sir.... - gargone 9 years ago
    • Yes sir! Also once workbench is running take some of the kace stuff and paste it in. Play around with it by making changes to it etc and see how stuff works that way. Its a great resource - jdornan 9 years ago
  • This is somewhat dated but helped alot.
    http://www.fatepublishing.com/uploads/5/8/9/3/5893663/033010-dbaccesswalkthrough.pdf - gargone 9 years ago
  • Should provide hrs of fun.....thanx. - gargone 9 years ago
  • All good links except the last one...page not found. - gargone 9 years ago
  • weird... click mysql on the menu bar above and it takes you to the same page but works - jdornan 9 years ago
  • yea figured that out about 3 seconds after I clicked the comment button. - gargone 9 years ago
Posted by: jverbosk 9 years ago
Red Belt
1

I'm assuming you're referring to my primer blog.  I've written/analyzed other techniques in these others, they might help give you some ideas.  Others' queries (and query requests) tend to be the best resource for doing things, and there's quite a supply here already on ITNinja.  My advice - if you don't understand something in a query, Google the term/function and play with it until you do.

Ultimately, though, the best learning tool is searching on Google for what you're specifically trying to do and then playing with the MySQL Query Browser (or equivalent).  Honestly, that's all I do - figure out what I want to do, Google to try and find a way to do it, play with a simplified query until I understand the mechanics, and then work up to the full query (often with multiple transitional queries).

Any specific questions, just let us know.

John

__________________________

http://www.itninja.com/blog/view/k1000-reports-advanced-mysql-query-techniques-parsing-multiple-substrings-from-a-field-using-temporary-tables

http://www.itninja.com/blog/view/k1000-reports-querying-and-reporting-on-network-printer-error-and-status-codes

http://www.itninja.com/blog/view/k1000-custom-ticket-rules-using-an-inline-view-to-query-update-tables-in-one-pass

http://www.itninja.com/blog/view/k1000-custom-ticket-rules-closing-parent-tickets-automatically-when-all-child-tickets-are-closed

* I should note that GillySpy actually has a ticket rule that fully works for what I was trying to accomplish with this last one.  I'm not the master of ticket rules (still have to sort out a couple of points...), but the approach and overall strategy are still worthwhile to read for the query tricks.


Comments:
  • Also, for what it's worth (and this is probably obvious if you read through my early posts), I've never had training on SQL. It's all been learning through play - my favorite way to learn. ^_^

    John - jverbosk 9 years ago
  • I actually have your blog saved on my desktop. Yea, its rather good to have a PhD in Google. I appreciate all the info and effort, I assure you it wont go to waste..... - gargone 9 years ago
  • Also, I'm pretty sure I included this in the primer blog, but the MySQL 5.1 Reference Manual is a great place for finding functions, syntax and examples (particularly the posts at the bottom of each manual page, where others share their solutions). For example, here's the page on string functions, which I referenced very frequently while writing up my Advanced SQL article:

    http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

    My K1100 is running version 5.1.54 of MySQL, you can determine your own by running:

    SHOW VARIABLES LIKE '%VERSION%'

    from the MySQL Query Browser. Probably the same, but you never know. ^_^

    John - jverbosk 9 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ