USE jawiki_p;
SELECT * FROM categorylinks c
INNER JOIN page p ON c.cl_from =... |
5 years ago |
USE jawiki_p;
SELECT * FROM categorylinks c
INNER JOIN page p ON c.cl_from =... |
5 years ago |
USE jawiki_p;
SELECT * FROM categorylinks c
INNER JOIN page p ON c.cl_from =... |
5 years ago |
USE jawiki_p;
SELECT * FROM categorylinks c
INNER JOIN page p ON c.cl_from =... |
5 years ago |
USE enwiki_p;
SELECT COUNT(*) FROM externallinks
WHERE el_to LIKE '%doi\.org%'; |
5 years ago |
USE jawiki_p;
SELECT COUNT(*) FROM externallinks
WHERE el_to LIKE '%doi\.org%'; |
5 years ago |
USE jawiki_p;
SELECT COUNT(*) FROM externallinks; |
5 years ago |
USE jawiki_p;
DESC externallinks; |
5 years ago |
USE jawiki_p;
show tables; |
5 years ago |
show databases; |
5 years ago |
USE jawiki; |
5 years ago |
use jawiki; |
5 years ago |