use zhwiki_p;
SELECT P.page_namespace, P.page_title, I.iwl_prefix,... |
6 years ago |
use zhwiki_p;
SELECT P.page_namespace, P.page_title, I.iwl_prefix,... |
6 years ago |
use zhwiki_p;
SELECT I.iwl_prefix, I.iwl_title, P.page_namespace,... |
6 years ago |
use zhwiki_p;
SELECT *
FROM iwlinks
WHERE iwl_prefix = "komicawiki"; |
6 years ago |
use zhwiki_p;
SELECT *
FROM iwlinks
WHERE iwl_prefix LIKE "komicawiki"; |
6 years ago |
use zhwiki_p;
SELECT *
FROM iwlinks
WHERE iwl_prefix LIKE "komicawiki"
LIMIT 10; |
6 years ago |
use zhwiki_p;
SELECT *
FROM iwlinks
WHERE iwl_prefix LIKE "KomicaWiki"
LIMIT 10; |
6 years ago |
use zhwiki_p;
SELECT *
FROM iwlinks
LIMIT 10; |
6 years ago |
use zhwiki_p;
SELECT *
FROM iwlinks
LIMIT 1; |
6 years ago |
use zhwiki_p;
SELECT COUNT(1)
FROM iwlinks
LIMIT 10; |
6 years ago |
use zhwiki_p;
SELECT COUNT(1)
FROM iwlinks
WHERE iwl_prefix = "KomicaWiki"
LIMIT 10; |
6 years ago |
use jawiki_p;
SELECT COUNT(1)
FROM iwlinks
WHERE iwl_prefix = 'KomicaWiki'; |
6 years ago |
use enwiki_p;
SELECT COUNT(1)
FROM iwlinks
WHERE iwl_prefix = 'KomicaWiki'; |
6 years ago |