7
edits
Bugzilla:SQLCookBook: Difference between revisions
→Bugzilla mysql queries
(→List the product_id's of all the products in a particular classification: Added a new recipe) |
|||
| Line 4: | Line 4: | ||
Please feel free to edit these for current practice. | Please feel free to edit these for current practice. | ||
If you want to learn to write your own SQL query for a Bugzilla search, you can start by doing a search in Bugzilla, and then add <tt>&debug=1</tt> to the URL of the query result page. Then it will output a bunch of stuff, including the SQL statement that it uses to search for the bugs. You can take that and edit it to suit your needs. --[[User:Newacct|Newacct]] 19:58, 16 July 2010 (UTC) | |||
===List all the classifications=== | ===List all the classifications=== | ||