| SELECT table_name, column_name, column_type FROM information_schema.colummns... |
7 years ago |
| SELECT @@version;
USE bgwiki_p;
select rev_text FROM revision LIMIT... |
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
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_user = 0 AND rev_timestamp >... |
7 years ago |
| USE bgwiki_p;
SELECT * FROM revision WHERE rev_timestamp > NOW() - INTERVAL... |
7 years ago |
| USE bgwiki_p;
SELECT * FROM revision LIMIT 5; |
7 years ago |
| USE bgwiki_p;
SELECT DISTINCT pp_value FROM page_props LIMIT 20; |
7 years ago |
| USE bgwiki_p;
SELECT DISTINCT pp_value FROM page_props WHERE pp_propname =... |
7 years ago |
| USE bgwiki_p;
SELECT DISTINCT pp_propname FROM page_props; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props LIMIT 5; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props LIMI 5; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props; |
7 years ago |
| USE bgwiki_p;
SELECT DISTINCT page_content_model FROM page_props; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props WHERE page_title LIKE 'Мими%' LIMIT... |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_prop WHERE page_title LIKE 'Мими%' LIMIT... |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page WHERE page_title LIKE 'Мими%' LIMIT 10; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page LIMIT 10; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props LIMIT 10; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props LIMIT 1; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM page_props LIMI 1; |
7 years ago |
| USE bgwiki_p;
SHOW TABLES; |
7 years ago |
| USE wikidatawiki_p;
SHOW TABLES; |
7 years ago |
| USE bgwiki_p;
SELECT * FROM revision LIMIT 1; |
7 years ago |
| use bgwiki;
select * from category limit 10; |
7 years ago |
| use bgwiki;
show create table category; |
7 years ago |
| use bgwiki;
show table status; |
7 years ago |
| use bgwiki;
show tables; |
7 years ago |
| use bgwiki |
7 years ago |
| select * from bgwiki.ipblock limit 10; |
7 years ago |
| select * from bgwiki.ipblock limit 10; |
7 years ago |
| select * from bgwiki.ipblock limit 10; |
7 years ago |
| select * from ipblock.bgwiki limit 10; |
7 years ago |
| SHOW TABLES FROM bgwiki; |
7 years ago |
| SHOW DATABASES;
SHOW GRANTS; |
7 years ago |
| SHOW TABLES; |
7 years ago |
| SELECT @@version; |
7 years ago |
