| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828 order... |
4 years ago |
| select concat("Wikipedia:",page_title),concat("Wikipedia:",rd_title)
from... |
4 years ago |
| select concat("Wikipedia:",page_title),concat("Wikipedia:",rd_title)
from... |
4 years ago |
| select concat("Wikipedia:",page_title),concat("Wikipedia:",rd_title)
from... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=4... |
4 years ago |
| select * from redirect join page on page_id=rd_from limit 5; |
4 years ago |
| select * from redirect join page on page_id=rd_from; |
4 years ago |
| select * from redirect limit 3; |
4 years ago |
| select * from page_restrictions join page on pr_page=page_id where... |
4 years ago |
| select * from page_restrictions join page on pr_page=page_id where... |
4 years ago |
| select
concat("Module:", page_title) as "Page"
from
templatelinks a
... |
4 years ago |
| select
concat("Module:", page_title) as "Page"
from
templatelinks a
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks a
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
from
templatelinks
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
count(limited.tl_from)... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
count(limited.tl_from)... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
(
select
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
(
select
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
(
select
... |
4 years ago |
| select
concat("Module:", page_title) as "Page",
(
select
... |
4 years ago |
| select count(*) from page limit 100; |
4 years ago |
| select
concat("Module:", page_title) as "Page",
(
select
... |
4 years ago |
| explain select
concat("Module:", page_title) as "Page",
(
select
... |
4 years ago |
| select concat("Module:",page_title) as "Page", (select count(*) from... |
4 years ago |
| select * from templatelinks join page on page_id=tl_from where... |
4 years ago |
| select * from templatelinks join page on page_id=tl_from where... |
4 years ago |
| select * from templatelinks join page on page_id=tl_from where... |
4 years ago |
| select (select page_title from page where page_id=cl_from), cl_timestamp... |
4 years ago |
| select * from categorylinks where cl_to="Templates_using_under-protected_Lua_modules" |
4 years ago |
| use metawiki_p;
select * from archive where ar_rev_id=20148400 |
4 years ago |
| use metawiki_p;
select * from archive where ar_revid=20148400 |
4 years ago |
| use metawiki_p;
select * from revision where rev_id=20148400 |
4 years ago |
| use mediawikiwiki_p;
select rev_timestamp,... |
4 years ago |
| use mediawikiwiki_p;
select rev_timestamp,... |
4 years ago |
| use mediawikiwiki_p;
select... |
4 years ago |
| use mediawikiwiki_p;
select... |
4 years ago |
| use mediawikiwiki_p;
select actor_name,concat("Extension",page_title) as... |
4 years ago |
| use mediawikiwiki_p;
select actor_name,concat("Extension",page_title) as... |
4 years ago |
| use mediawikiwiki_p;
select actor_name,concat("Extension",page_title) as... |
4 years ago |
| use mediawikiwiki_p;
select * from revision_userindex
join comment_revision... |
4 years ago |
| use mediawikiwiki_p;
select * from revision_userindex
join comment_revision... |
4 years ago |
| use mediawikiwiki_p;
select * from revision_userindex
join comment_revision... |
4 years ago |
| use mediawikiwiki_p;
select * from revision
join comment_revision on... |
4 years ago |
| use mediawikiwiki_p;
select * from revision
join comment_revision on... |
4 years ago |
| use mediawikiwiki_p;
select * from revision
join comment_revision on... |
4 years ago |
| select * from templatelinks where tl_namespace=0
and tl_from != (select... |
4 years ago |
| select * from templatelinks where tl_namespace=0 and tl_from != (select... |
4 years ago |
| select * from templatelinks where tl_namespace=0 and tl_from != (select... |
4 years ago |
| SELECT lag FROM heartbeat_p.heartbeat JOIN meta_p.wiki ON shard =... |
4 years ago |
| select distinct up_property from user_properties;
SELECT rev_id,... |
4 years ago |
| select distinct up_property from user_properties;
SELECT rev_id,... |
4 years ago |
| select distinct up_property from user_properties;
SELECT rev_id,... |
4 years ago |
| select distinct up_property from user_properties; |
4 years ago |
| select distinct up_prop from user_properties; |
4 years ago |
| show index from user_properties; |
4 years ago |
| show indexes on user_properties; |
4 years ago |
| show index on user_properties; |
4 years ago |
| describe user_properties; |
4 years ago |
| select * from enwiki_p.user_properties where up_user=(select user_id from... |
4 years ago |
| select distinct up_prop from user_properties; |
4 years ago |
| select * from enwiki_p.user_properties where up_user=(select user_id from... |
4 years ago |
| select * from enwiki_p.user_properties limit 1; |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| use enwikinews_p;
set @9mo = "20190716000000";
set @12mo =... |
4 years ago |
| select * from metawiki_p.logging where log_type="rights" and log_action !=... |
4 years ago |
| select * from metawiki_p.logging where log_type="rights" limit 10; |
4 years ago |
| select * from metawiki_p.logging where log_type="rights" limit 1; |
4 years ago |
| use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer")... |
4 years ago |
| use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer")... |
4 years ago |
| use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer")... |
4 years ago |
| use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer")... |
4 years ago |
| use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer")... |
4 years ago |
| use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer")... |
4 years ago |
| use enwikinews_p;
select actor_name, ug_group from user_groups join... |
4 years ago |
| use enwikinews_p;
select actor_name, ug_group from user_groups join... |
4 years ago |
| use enwikinews_p;
select actor_name, ug_group from user_groups join... |
4 years ago |
| use enwikinews_p;
select actor_name from user_groups join actor_user on... |
4 years ago |
| use enwikinews_p;
select actor_name from user_groups join actor_user on... |
4 years ago |
| use enwikinews_p;
select actor_name from user_groups join actor_user on... |
4 years ago |
| select rev_comment_id, comment_text from revision_userindex join comment on... |
4 years ago |
| select rev_comment_id, comment_text from revision_userindex join comment on... |
4 years ago |
| select rev_comment_id, comment_text from revision_userindex join comment on... |
4 years ago |
| select rev_comment_id, comment_text from revision_userindex join comment on... |
4 years ago |
| select rev_comment_id, comment_text from revision_userindex join comment on... |
4 years ago |
| select * from revision_userindex where rev_actor=(select actor_id from... |
4 years ago |
| select * from revision_userindex where rev_actor=(select actor_id from... |
4 years ago |
| select coalesce("a",(select dbname from meta_p.wiki)); |
4 years ago |
| select coalesce("",(select dbname from meta_p.wiki)); |
4 years ago |
| select coalesce("",(select dbname from meta_p.wikis)); |
4 years ago |
| SELECT @Names = COALESCE(@Names + ', ', '') + dbname
FROM meta_p.wiki;
select @Names; |
4 years ago |
| SELECT @Names = COALESCE(@Names + ', ', '') + dbname
FROM meta_p.wiki;
select @names; |
4 years ago |
| SELECT @Names = COALESCE(@Names + ', ', '') + dbname
FROM meta_p.wiki; |
4 years ago |
| SELECT @Names = COALESCE(@Names + ', ', '') + dbname;
FROM meta_p.wiki; |
4 years ago |
| select * from meta_p.wiki; |
4 years ago |
| SELECT @Names = COALESCE(@Names + ', ', '') + Name
FROM People |
4 years ago |
| DECLARE @Names VARCHAR(8000)
SELECT @Names = COALESCE(@Names + ', ', '') +... |
4 years ago |
| select group_join("|",(select dbname from meta_p.wiki)) |
4 years ago |
| select concat("|",(select dbname from meta_p.wiki)) |
4 years ago |
| select concat("|",(select dbname from meta_p.wikis)) |
4 years ago |
| select * from meta_p.wiki; |
4 years ago |
| use meta_p;
show tables;
|
4 years ago |
| use meta_p;
show tables;
select * from meta_p.wikis; |
4 years ago |
| select * from meta_p.wikis; |
4 years ago |
| drop PROCEDURE if exists updateLocations;
|
4 years ago |
| drop PROCEDURE if exists updateLocations;
DELIMITER //
CREATE PROCEDURE... |
4 years ago |
| DELIMITER //
CREATE PROCEDURE updateLocations()
BEGIN
DECLARE rack INT... |
4 years ago |
| drop PROCEDURE if exists updateLocations;
DELIMITER //
CREATE PROCEDURE... |
4 years ago |
| FOR i IN 1..3
DO
END FOR; |
4 years ago |
| FOR i IN 1..3
DO
END FOR; |
4 years ago |
| FOR i IN 1..3
DO
INSERT INTO t1 VALUES (i);
END FOR; |
4 years ago |
| FOR i IN 1..3
DO
INSERT INTO t1 VALUES (i);
END FOR; |
4 years ago |
| FOR i IN 1..3
DO
INSERT INTO t1 VALUES (i);
END FOR; |
4 years ago |
| FOR i IN 1..3
DO select 1;
END FOR |
4 years ago |
| FOR @db in (select dbname from meta_p.wikis) DO END FOR |
4 years ago |
| FOR @db in (select dbname from meta_p.wikis); |
4 years ago |
| use meta_p;
select * from wiki; |
4 years ago |
| use meta_p;
show tables; |
4 years ago |
| select * from meta_p; |
4 years ago |
| set @cnt INT = 0;
WHILE @cnt < 10
BEGIN
PRINT 'Inside simulated FOR LOOP... |
4 years ago |
| select * from archive_compat where ar_namespace=0 and ar_title="Dorky9ss"; |
4 years ago |
| select * from archive_compat where ar_namespace=9 and ar_title="Dorky9ss"; |
4 years ago |
| select * from archive_compat where ar_namespace=9 and ar_title="Dorky9ss"; |
4 years ago |
| select * from archive_compat where ar_namespace=9 and ar_title="Dorky9ss"; |
4 years ago |
