Manual:Pagelinks table

The pagelinks table tracks all 1>m:Special:MyLanguage/Help:Link#Wikilinks|internal links in the wiki.

Each entry contains the source page's ID and namespace (number), and the article name (in text) and namespace (number) that is being linked to from within that source page.

There may be many instances of the source page's ID, as many as the internal links within it, but there can be only one entry per internal link for any page ID (or MySQL will yell out a fatal error).

Note that the target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

The table was introduced in version 1.5.

It is the result of merging the  table and the  table of version 1.4.

Regenerating the pagelinks table is always possible using the  maintenance script.

pl_from
The  of the page containing the link.

pl_from_namespace
The  of the page containing the link.

pl_namespace
The page_namespace</> of the target page.

The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

pl_title
The <tvar|1></> of the target page.

The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Spaces are converted to underscores, and the first letter is automatically capitalized.

So for example, a link to <tvar|1>foo bar</> would have a <tvar|3>pl_title</> of "<tvar|2>Foo_bar</>".

Schema summary
<tt>DESCRIBE pagelinks;</tt> +---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field            | Type             | Null | Key | Default | Extra |
 * pl_from          | int(10) unsigned | NO   | PRI | 0       |       |
 * pl_from_namespace | int(11)         | NO   | MUL | 0       |       |
 * pl_namespace     | int(11)          | NO   | PRI | 0       |       |
 * pl_title         | varbinary(255)   | NO   | PRI |         |       |

<tt>DESCRIBE pagelinks;</tt> +---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field            | Type             | Null | Key | Default | Extra |
 * pl_from          | int(10) unsigned | NO   | PRI | 0       |       |
 * pl_from_namespace | int(11)         | NO   |     | 0       |       |
 * pl_namespace     | int(11)          | NO   | PRI | 0       |       |
 * pl_title         | varbinary(255)   | NO   | PRI |         |       |

<tt>DESCRIBE pagelinks;</tt> +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type                | Null | Key | Default | Extra |
 * pl_from     | int(10) unsigned    | NO   | PRI | 0       |       |
 * pl_namespace | int(11)            | NO   | PRI | 0       |       |
 * pl_title    | varchar(255) binary | NO   | PRI | NULL    |       |

<tt>DESCRIBE pagelinks;</tt> +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type                | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned     | NO   | PRI | 0       |       |
 * pl_namespace | int(11)            | NO   | PRI | 0       |       |
 * pl_title    | varchar(255) binary | NO   | PRI | NULL    |       |