Open main menu
Home
Random
Recent changes
Special pages
Community portal
Preferences
About Wikipedia
Disclaimers
Incubator escapee wiki
Search
User menu
Talk
Dark mode
Contributions
Create account
Log in
Editing
Incubator escapee wiki:Help desk/Archive 13
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
== Help for articles and categories == We are working on GNU related content management project. Our project aims to create a semantic web enabled portal for content management.We are working at TIFR under the guidance of Dr.Nagarjuna G. We are currently working on the articles at the Wikipedia site. We have downloaded the cur (current) sql dump which has the entire content including the text of the articles. We are interested only in the names of the articles and the relationship to their categories. We have also tried the categorylinks db but, it gives us the ids of the articles and not their names. We would like to know if there is any table which just has the names of the articles and their categories. Thanking you, Sakecwiki team (TIFR) :There isn't one. You'll have to do an SQL join between cur and categorylinks. -- [[User:Cyrius|Cyrius]]|[[User talk:Cyrius|✎]] 12:50, 25 Jan 2005 (UTC)
Edit summary
(Briefly describe your changes)
By publishing changes, you agree to the
Terms of Use
, and you irrevocably agree to release your contribution under the
CC BY-SA 4.0 License
and the
GFDL
. You agree that a hyperlink or URL is sufficient attribution under the Creative Commons license.
Cancel
Editing help
(opens in new window)