Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Why is the Page ID not sequential?

10 views
Skip to first unread message

Martin Min

unread,
Mar 28, 2016, 1:10:23 AM3/28/16
to jwpl-users
Hi, I have followed this tutorial to created the database and populated the tables.  I am wondering why the page id is not sequential. The following are the first 20 page ids from the database:

MariaDB [Wikipedia]> select Page.id,Page.pageId from Page limit 0,20;
+-----+--------+
| id  | pageId |
+-----+--------+
|  12 |     12 |
|  25 |     25 |
|  39 |     39 |
| 290 |    290 |
| 303 |    303 |
| 305 |    305 |
| 307 |    307 |
| 308 |    308 |
| 309 |    309 |
| 316 |    316 |
| 324 |    324 |
| 330 |    330 |
| 332 |    332 |
| 334 |    334 |
| 336 |    336 |
| 339 |    339 |
| 340 |    340 |
| 344 |    344 |
| 358 |    358 |
| 359 |    359 |
+-----+--------+

Also, is the "id" field redundant here? 


Alberto Barron Cedeno

unread,
Mar 28, 2016, 3:51:44 AM3/28/16
to jw...@googlegroups.com
Hi Martin,

as far as I know, the ids are the unique identifiers from the Wikipedia edition itself. If article associated to id 13 was removed or is not accessible for some reason, you will not have it. 

Best regards,
Alberto

--
You received this message because you are subscribed to the Google Groups "jwpl-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jwpl+uns...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Martin Min

unread,
Mar 28, 2016, 11:18:11 AM3/28/16
to jwpl-users
Thank you, Alberto. Just want to get a confirmation on this.

Martin
Reply all
Reply to author
Forward
0 new messages