Search results
Results from the WOW.Com Content Network
Much of the data that makes up the Wikipedia encyclopedia is stored in a SQL database. It can sometimes be useful to run queries against this database to extract information that is otherwise hard to find. For example: Articles with H.M.S. in their title that have not been edited for 12 months.
An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition. The UPDATE statement has the following form: [1] UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]
SQL queries that would execute in a fraction of a second on a smaller database may take over an hour and then time out when run on Quarry and enwiki. Here are some tips to make your SQL queries as efficient as possible. Test your query on a smaller wiki, such as simplewiki (612,000 articles) or sawiki (11,000 articles). Use a LIMIT.
R2 is also included here, since legitimate R2 deletions usually happen in days, and months-old revisions deleted under an R2 may imply an admin failed to check the history before deleting. G3 is also included here, to check for cases where a page is vandalized and an admin deleted rather than reverting the vandalism, and as a reminder to update ...
If you need to make changes to a number of articles based on a particular query, you can post to the bot requests page, depending on how many changes are needed. For long-term review and checking, database reports are available. Quarry does not have access to page content, so queries which require checking wikitext cannot be answered with Quarry.
Suppress visible output from this template. Only the table generated by the bot will be visible. The last update timestamp and query runtime are also not saved. This means that if the query result is unchanged, periodic updates won't reflect in the page history. This is a boolean field - any value will work.
Title Authors ----- ----- SQL Examples and Guide 4 The Joy of SQL 1 An Introduction to SQL 2 Pitfalls of SQL 1 Under the precondition that isbn is the only common column name of the two tables and that a column named title only exists in the Book table, one could re-write the query above in the following form:
Get yourself a mysql database. It's free to download, easy to set up and runs on most types of computer. The process should work on any reasonably recent version of the mysql software. Download the latest page and pagelinks tables from here. There are normally labelled enwiki-latest-page.sql.gz and enwiki-latest-pagelinks.sql.gz respectively.