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
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
Community Chosen Answer
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.