All pastes #812921 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-12-12 02:48 UTC
rendered paste body
mysql> SELECT wikidb.pagelinks.pl_from,wikidb_quality.page.page_id FROM wikidb.pagelinks INNER JOIN wikidb.page ON (wikidb_quality.page.page_title = wikidb.page.page_title) GROUP BY (wikidb.pagelinks.pl_from) limit 10;ERROR 1054 (42S22): Unknown column 'wikidb_quality.page.page_id' in 'field list'mysql> use wikidb_quality;Database changedmysql> describe page;+-------------------+---------------------+------+-----+---------+----------------+| Field             | Type                | Null | Key | Default | Extra          |+-------------------+---------------------+------+-----+---------+----------------+| page_id           | int(8) unsigned     | NO   | PRI | NULL    | auto_increment || page_namespace    | int(11)             | NO   | MUL |         |                || page_title        | varchar(255)        | NO   | MUL |         |                || page_restrictions | tinyblob            | NO   |     |         |                || page_counter      | bigint(20) unsigned | NO   |     | 0       |                || page_is_redirect  | tinyint(1) unsigned | NO   |     | 0       |                || page_is_new       | tinyint(1) unsigned | NO   |     | 0       |                || page_random       | double unsigned     | NO   | MUL |         |                || page_touched      | char(14)            | NO   |     |         |                || page_latest       | int(8) unsigned     | NO   |     |         |                || page_len          | int(8) unsigned     | NO   | MUL |         |                |+-------------------+---------------------+------+-----+---------+----------------+11 rows in set (0.63 sec)