Search results
Results from the WOW.Com Content Network
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]
Uncompress the database with bzip2. Other uncompression software may fail silently. Install and start AutoWikiBrowser. In the pane on the left, change the dropdown to "Database dump" and click the button labeled "Make list." In the Wiki Database Scanner window that appears, select "File" from the menu, and select the XML file which bzip2 ...
Note: This page discusses the SQL dump format, which is now obsolete. New Wikipedia dumps are in XML format. This page is currently inactive and is retained for historical reference.
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.
To update an offline Wiki for WikiTaxi, download and import a more recent database dump. For WikiTaxi reading, only two files are required: WikiTaxi.exe and the .taxi database. Copy them to any storage device (memory stick or memory card) or burn them to a CD or DVD and take your Wikipedia with you wherever you go!
What links here; Related changes; Upload file; Special pages; Permanent link; Page information; Get shortened URL; Download QR code
Some pages already provide a link to purge the page, such as the Wikipedia:Templates for discussion page . Simply click on the link to purge the page. (WP:TFD transcludes subpages like Wikipedia:Templates for discussion/Log/2025 January 2, and updates from these subpages are not always reflected in WP:TFD. By purging, you will see the most ...
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.