|
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
|
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| /*
SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| SET @project = "frwikiquote_p.user";
set @qry1:= concat('select user_id,... |
4 years ago |
| SET @project = "frwikiquote_p.user, eswikiquote_p.user";
set @qry1:=... |
4 years ago |
| SET @project = "frwikiquote_p.user, eswikiquote_p.user";
set @qry1:=... |
4 years ago |
| SET @project = "frwikiquote_p";
SET @table := concat(@project,'.user');
set... |
4 years ago |
| SET @project = "frwikiquote_p, enwikiquote_p";
SET @table :=... |
4 years ago |
| SET @project = "frwikiquote_p";
SET @table := concat(@project,'.user');
set... |
4 years ago |
| SET @project = "frwikiquote_p";
SET @table := concat(@project,'.user');
set... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikiquote_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwiki_p";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = ("frwikip", "John");
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "frwikip,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "karl,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "karl,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "karl,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "karl,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "karl,John";
#SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = "karl,John";
SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = elt('karl', 'John');
SELECT find_in_set(@projects) as... |
4 years ago |
| SET @projects = elt('karl', 'John');
SELECT @projects as project;
/*
SELECT... |
4 years ago |
| SET @projects = '{"karl", "John"}';
select json_value('{"key1":123}',... |
4 years ago |
| SET @projects = '{"karl", "John"}';
SELECT JSON_VALUE(@projects,... |
4 years ago |
| SET @projects = '{"karl", "John"}';
SELECT JSON_VALUE(@projects, '$[0]') as... |
4 years ago |
| SET @projects = '["label", "karl"]';
SELECT JSON_VALUE(@projects, '$[0]') as... |
4 years ago |
| SET @projects = '["label", "karl"]';
SELECT JSON_VALUE(@projects, '$[0]') as... |
4 years ago |
| SET @projects = '["frwikiquote_p", "enwiki_p"]';
SELECT... |
4 years ago |
| SET @projects = "frwikiquote_p, enwiki_p";
SELECT DISTINCT @projects as... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT DISTINCT @projects as... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * from (SELECT DISTINCT @projects)... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * from (SELECT DISTINCT... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * from @projects;
/*
SELECT... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * from DISTINCT @projects;
/*
SELECT... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT user_id, user_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT ug_name, ug_group, ug_editcount FROM... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT ug_id, ug_name, ug_group,... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p.user as... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p.user as... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p.user as... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p.user as... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p.user;
user join... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p.user;
user join... |
4 years ago |
| SET @projects = "frwikiquote_p";
SELECT * FROM frwikiquote_p as... |
4 years ago |
| SET @projects = "frwiki_p";
SELECT * FROM frwikiquote_p;
user join... |
4 years ago |
| SET @projects = "frwiki_p";
SELECT * FROM frwiki_p;
user join user_groups on... |
4 years ago |
| SET @projects = "frwiki_p";
SELECT * FROM @projects;
user join user_groups... |
4 years ago |
| SET @projects = "frwiki_p,eswiki_p";
SELECT * FROM @projects;
/*... |
4 years ago |
| SET @projects = "frwiki_p,eswiki_p";
SELECT DISTINCT @projects;
/*... |
4 years ago |
| SET @projects = ("frwiki_p,eswiki_p");
SELECT DISTINCT @projects;
/*... |
4 years ago |
| SET @projects = ("frwiki_p", "eswiki_p");
SELECT @projects AS project;
... |
4 years ago |
| SET @projects = ("frwiki_p,eswiki_p");
SELECT @projects AS project;
... |
4 years ago |
| SET @projects = ("frwiki_p,eswiki_p");
SELECT DISTINCT @projects AS... |
4 years ago |
| SET @projects = ("frwiki_p,eswiki_p");
SELECT *
FROM
(SELECT DISTINCT... |
4 years ago |
| SET @projects = ("frwiki_p,eswiki_p");
SELECT ug_user, user_id,... |
4 years ago |
| show databases;
/* select * from user join user_groups on ug_user = user_id... |
4 years ago |
| select * from information_schema
/* select * from user join user_groups on... |
4 years ago |
| describe frwiki
/* select * from user join user_groups on ug_user = user_id... |
4 years ago |
| describe frwiki_p
/* select * from user join user_groups on ug_user =... |
4 years ago |
| describe information_schema
/* select * from user join user_groups on... |
4 years ago |
| select schema_name as database_name
from information_schema.schemata
where... |
4 years ago |
| select schema_name as database_name
from information_schema.schemata
where... |
4 years ago |
| select schema_name as database_name
from information_schema.schemata
order... |
4 years ago |
| SELECT * FROM databases;
/* select * from user join user_groups on ug_user =... |
4 years ago |
| SELECT * FROM schemas;
/* select * from user join user_groups on ug_user =... |
4 years ago |
| SELECT schema_name
FROM schemas;
/* select * from user join user_groups on... |
4 years ago |
| show schemas;
/* select * from user join user_groups on ug_user = user_id... |
4 years ago |
| describe databases;
/* select * from user join user_groups on ug_user =... |
4 years ago |
| show databases
limit 4
;
/* select * from user join user_groups on ug_user =... |
4 years ago |
| show databases
limit 4;
/* select * from user join user_groups on ug_user =... |
4 years ago |
| show databases;
/* select * from user join user_groups on ug_user = user_id... |
4 years ago |
| SELECT schema_name
FROM information_schema.schemata
WHERE schema_name LIKE... |
4 years ago |
| SELECT * FROM databases
/* select * from user join user_groups on ug_user =... |
4 years ago |
| SELECT *
FROM database
|
4 years ago |
| SELECT *
FROM database
/* select * from user join user_groups on ug_user =... |
4 years ago |
| SELECT DISTINCT SCHEMA_NAME AS `database`
FROM information_schema.SCHEMATA
... |
4 years ago |
| select * from user join user_groups on ug_user = user_id and ug_group =... |
4 years ago |
| select user_name from user join user_groups on ug_user = user_id and... |
4 years ago |
| select user_name from user join user_groups on ug_user = user_id and... |
4 years ago |
