| USE bgwiki_p;
SELECT rev_user_text, COUNT(*) c
FROM revision
WHERE... |
7 years ago |
| USE bgwiki_p;
SELECT rev_user_text, COUNT(*) c
FROM revision
WHERE... |
7 years ago |
| USE bgwiki_p;
SELECT rev_user_text, COUNT(*) c
FROM revision
WHERE... |
7 years ago |
| USE bgwiki_p;
SELECT rev_user_text, COUNT(*) c
FROM revision
WHERE... |
7 years ago |
| USE bgwiki_p;
SELECT * FROM revision WHERE rev_timestamp >= CURDATE() LIMIT 1; |
7 years ago |
| USE bgwiki_p;
SELECT COUNT(*) FROM revision WHERE rev_timestamp >= CURDATE(); |
7 years ago |
| USE bgwiki_p;
SELECT COUNT(*) FROM revision WHERE rev_timestamp >= CURDATE(); |
7 years ago |
| USE bgwiki_p;
SELECT COUNT(*) FROM revision WHERE rev_timestamp >= CURDATE(); |
7 years ago |
| USE bgwiki_p;
SELECT * FROM revision order by rev_timestamp desc LIMIT 100; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM revision LIMIT 10; |
7 years ago |
| USE bgwiki_p;
SHOW TABLE STATUS; |
7 years ago |
| USE bgwiki;
SHOW TABLE STATUS; |
7 years ago |
| SELECT @@version;
SHOW TABLE STATUS; |
7 years ago |
| SELECT @@version;
USE bgwiki_p;
SELECT rev_user_text u, YEAR(rev_timestamp)... |
7 years ago |
| SELECT @@version;
USE bgwiki_p;
SELECT rev_user_text u, YEAR(rev_timestamp)... |
7 years ago |
| SELECT @@version;
USE bgwiki_p;
SELECT rev_user_text, COUNT(*) c
FROM... |
7 years ago |
| use bgwiki_p;
select rev_user_text, count(*) c
from revision
group by... |
7 years ago |
| use bgwiki_p;
select year(rev_timestamp) y, count(*) from revision where... |
7 years ago |
| use bgwiki_p;
select * from revision where rev_user_text = 'Сале' limit 10; |
7 years ago |
| use bgwiki_p;
select * from revision where rev_user = 'Сале' limit 10; |
7 years ago |
| use bgwiki_p;
select * from revision limit 10; |
7 years ago |
| use bgwiki_p;
show tables;
|
7 years ago |
| use bgwiki_p;
show tables like "%page%";
|
7 years ago |
| SELECT @@version;
USE bgwiki_p;
SELECT * FROM page LIMIT 5;
|
7 years ago |
| SELECT @@version;
USE bgwiki_p;
SHOW TABLES;
|
7 years ago |
| SELECT @@version; |
7 years ago |
| USE bgwiki_p;
SELECT @@version; |
7 years ago |
| use bgwiki_p;
select * from recentchanges_userindex limit 10; |
7 years ago |
| use bgwiki_p;
select * from recentchanges_userindex; |
7 years ago |
| use bgwiki_p;
show tables like "%user%"; |
7 years ago |
| use bgwiki_p;
show tables like "user%"; |
7 years ago |
| use bgwiki_p;
select user_name,... |
7 years ago |
| use bgwiki_p;
select user_name,... |
7 years ago |
| use bgwiki_p;
select... |
7 years ago |
| use bgwiki_p;
select user_name, DATE_FORMAT(user_registration, '%Y-%m-%d... |
7 years ago |
| use bgwiki_p;
select user_name, DATE_FORMAT(user_registration, '%Y-%m-%d... |
7 years ago |
| use bgwiki_p;
select GROUP_CONCAT(user_name) from user where... |
7 years ago |
| use bgwiki_p;
select * from user where user_name = 'Сале'; |
7 years ago |
| use bgwiki_p;
select user_email from user where user_name = 'Сале'; |
7 years ago |
| use bgwiki_p;
select * from user limit 1; |
7 years ago |
| use bgwiki_p;
show tables; |
7 years ago |
| use bgwiki_p;
select * from ipblocks limit 10; |
7 years ago |
| use bgwiki_p;
show tables; |
7 years ago |
| use bgwiki_p;
select * from ipblock limit 10; |
7 years ago |
| use bgwiki_p;
show create table category; |
7 years ago |
| use bgwiki_p;
select * from category where cat_title like "%Рим%" limit 1; |
7 years ago |
| use bgwiki_p;
select * from category where cat_title like "Древен Рим%" limit 1; |
7 years ago |
| use bgwiki_p;
select * from category limit 1; |
7 years ago |
| show databases like "%bg%"; |
7 years ago |
| show databases like "%bg%"; |
7 years ago |
