On Nov 20 2009, Platonides wrote: >Zeyi wrote: >> I took the sub-current data from MediaWiki and import them to Oracle. >Which tool did you use for the import? > I used xml2sql tool, which is easy to use.
>> I found there are two same page_latest ID in the page table. Then when >> I tried to join Revision table and Page table together, this caused two >> same rev_id. > >Which pages are those? kinds of every pages, is that page_latest ID unique? > > >> May I ask why I have two page_latest on page table, what it mean? If I >> want to put Revision table and Page table together, which should be the >> link point? > >You shouldn't have that situation. >And why are you merging page and revision, anyway? I need use rev_user and page_namespace to do crossing-analysis. How i can put them in the one table? thanks again. >> thanks, >> Zeyi > > >_______________________________________________ >Wikitech-l mailing list >[email protected] >https://lists.wikimedia.org/mailman/listinfo/wikitech-l > _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
