| use frwiki_p;
select a.actor_name from frwiki_p.actor a
left join... |
4 years ago |
| use frwiki_p;
select * from frwiki_p.actor a
where a.actor_name = "African Hope"
; |
4 years ago |
| use frwiki;
show tables; |
4 years ago |
| SELECT a.actor_name, r.rev_id, r.rev_parent_id
FROM frwiki_p.revision... |
4 years ago |
| SELECT a.actor_name, r.rev_id, r.rev_parent_id
FROM frwiki_p.revision... |
4 years ago |
| SELECT a.actor_name, r.rev_id, r.rev_parent_id
FROM frwiki_p.revision... |
4 years ago |
| SELECT a.actor_name, r.rev_id, r.rev_parent_id
FROM frwiki_p.revision... |
4 years ago |
| SELECT a.actor_name, r.rev_id, r.rev_parent_id
FROM frwiki_p.revision... |
4 years ago |
| SELECT a.actor_name, r.rev_id, r.rev_parent_id
FROM frwiki_p.revision... |
4 years ago |
| SELECT *
FROM frwiki_p.revision r
LEFT JOIN frwiki_p.actor a ON a.actor_id... |
4 years ago |
| SELECT *
FROM ptwiki_p.revision r
LEFT JOIN ptwiki_p.actor a ON a.actor_id... |
4 years ago |
| SELECT *, a.actor_name
FROM ptwiki_p.revision r
LEFT JOIN ptwiki_p.actor a... |
4 years ago |
| SELECT r.rev_id, a.actor_name
FROM ptwiki_p.revision r
LEFT JOIN... |
4 years ago |
| use ptwiki_p;
show tables;
|
4 years ago |
| use ptwiki_p;
select
rev_id, a.actor_name
from
revision as r
left join... |
4 years ago |
| use ptwiki_p;
select * from revision where rev_id = "52892454";
|
4 years ago |
| use frwiki_p;
select * from revision where rev_id = "52892454";
|
4 years ago |
| use frwiki_p;
show tables;
|
4 years ago |
| use frwikipedia_p;
show tables;
|
4 years ago |
| show databases;
|
5 years ago |
| SELECT *
FROM centralauth_p.globaluser
WHERE gu_name = "African Hope"
LIMIT 5;
|
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_name =... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_email =... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_email LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_name LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_name LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_name LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_email LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
LIMIT 5; |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_email LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_email LIKE... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE gu_email =... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE LIKE gu_email... |
5 years ago |
| SELECT gu_name, gu_email
FROM centralauth_p.globaluser
WHERE LIKE... |
5 years ago |
| show databases; |
5 years ago |
| describe table centralauth_p; |
5 years ago |
| describe centralauth_p; |
5 years ago |
| show databases; |
5 years ago |
