| use hrwiki_p;
select * from actor order by actor_id desc limit 10; |
3 years ago |
| use hrwiki_p;
select * from actor order by actor_id desc limit 10; |
3 years ago |
| use hrwiki_p;
select * from actor order by actor_id desc limit 10; |
3 years ago |
| use hrwiki_p;
select * from actor limit 10; |
3 years ago |
| use hrwiki_p;
show tables; |
3 years ago |
| use hrwiki_p;
select * from ipblocks order by ipb_id desc limit 200; |
3 years ago |
| use hrwiki_p;
select * from ipblocks order by ipb_id desc limit 20; |
3 years ago |
| use hrwiki_p;
select * from ipblocks limit 20; |
3 years ago |
| use hrwiki_p;
describe linter; |
3 years ago |
|
select * from page_props where pp_page=32323 limit 5; |
3 years ago |
|
select * from page_props limit 5; |
3 years ago |
|
describe page_props; |
3 years ago |
|
describe text; |
3 years ago |
|
describe content; |
3 years ago |
| use hrwiki_p;
describe content; |
3 years ago |
| use hrwiki_p;
describe text; |
3 years ago |
| use hrwiki_p;
select * from revision order by rev_id desc limit 5; |
3 years ago |
| use hrwiki_p;
select * from revision limit 5; |
3 years ago |
| use enwiki_p;
select * from user_properties where up_user =38361 limit 5; |
3 years ago |
| use hrwiki_p;
select * from user_properties where up_user =38361 limit 5; |
3 years ago |
| use hrwiki_p;
select * from user where user_name='Ponor'; |
3 years ago |
| use hrwiki_p;
select * from user_properties where up_user > 35000 limit 5; |
3 years ago |
| use hrwiki_p;
select * from user_properties limit 5; |
3 years ago |
| use hrwiki_p;
select * user_properties limit 5; |
3 years ago |
| use hrwiki_p;
SHOW COLUMNS FROM user_properties; |
3 years ago |
| use hrwiki_p;
show tables; |
3 years ago |
| use hrwiki_p;
SHOW COLUMNS FROM content; |
3 years ago |
| use hrwiki_p;
SHOW COLUMNS FROM page; |
3 years ago |
| use hrwiki_p;
SHOW COLUMNS FROM user; |
3 years ago |
| use hrwiki_p;
select * from page where page_title like 'Elek%' limit 2; |
3 years ago |
| use hrwiki_p;
select * from page where page_title like 'Elek%' imit 2; |
3 years ago |
| use hrwiki_p;
select * from page lwhere page_title like 'Elek%' imit 2; |
3 years ago |
| use hrwiki_p;
select * from page limit 2; |
3 years ago |
| use hrwiki_p;
select * from page where page_name like 'Elek%' limit 2; |
3 years ago |
| use hrwiki_p;
select * from page where page like 'Elek%' limit 2; |
3 years ago |
| use hrwiki_p;
select * from page limit 2; |
3 years ago |
| use hrwiki_p;
show tables; |
3 years ago |
| use hrwiki_p;
select user_id, user_name, user_editcount from user order by... |
3 years ago |
| use hrwiki_p;
select user_id, user_name, user_editcount from user where... |
3 years ago |
| select user_id, user_name, user_editcount from user where... |
3 years ago |
| use hrwiki_p;
select user_id, user_name, user_editcount from user where... |
3 years ago |
| use hrwiki_p;
select user_id, user_name, user_editcount from user where... |
3 years ago |
| use hrwiki_p;
select * from user where user_editcount>200 order by user_id limit 20; |
3 years ago |
| use hrwiki_p;
select * from user order by user_id limit 20; |
3 years ago |
| use hrwiki_p;
select * from user sort by user_id 20; |
3 years ago |
| use hrwiki_p;
select * from user order by user_id 20; |
3 years ago |
| use hrwiki_p;
select * from user where user_name like 'Pono%' limit 20; |
3 years ago |
| use hrwiki_p;
select * from user where user_name like 'Pon%' limit 2; |
3 years ago |
| use hrwiki_p;
select * from user where user_name like 'Po%' limit 2; |
3 years ago |
| use hrwiki_p;
select * from user limit 2; |
3 years ago |
| use hrwiki_p;
show tables; |
3 years ago |
| use hrwiki_p;
select * from tables; |
3 years ago |
| use hrwiki_p; |
3 years ago |
| select * from databases; |
3 years ago |
| select * from tables; |
3 years ago |
| list databases |
3 years ago |
| list tables |
3 years ago |
| list tables; |
3 years ago |
