practical example queries (fully commented)
These are the sort of data analysis queries that will be handy to learn to compose when developing custom content.
NOTE: -- indicates a single-line comment (anything after will be ignored by MySQL) PURPOSE: List active tradeskill recipes without resulting on_success item present in database. NOTE: Demonstrates use of LEFT JOIN instead of a SELECT sub-query. Code:
SELECT -- SELECT indicates these are the fields we want Code:
+-----------------------------------------------+ |
PURPOSE: List info for active Proving Ground spawns (NOT scripted).
NOTE: Use SUM to combine chances to find groups with <> 100% total. Code:
SELECT -- SELECT indicates these are the fields we want Code:
+----------------+---------------+--------------+--------+--------------------------------+--------------+--------------+-------------+ |
PURPOSE: Export a a list of items made by tradeskills into a CSV file for later use.
NOTE: no (idea what i was typing here...) Code:
SELECT -- SELECT indicates these are the fields we want Code:
1057,"Mystic Cloak" |
PURPOSE: List all Proving Grounds spawn group entries with a combined chance of less or greater than 100%,
NOTE: https://mariadb.com/kb/en/library/aggregate-functions/ Code:
SELECT -- SELECT indicates these are the fields we want Code:
+----------------+---------------+--------------+ |
All times are GMT -4. The time now is 07:06 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.