| USE tcywiki_p;
show tables;
|
9 years ago |
| USE tewiki_p;
desc user;
select user_id, user_name, user_editcount from... |
9 years ago |
| USE knwiki_p;
desc user;
select user_id, user_name, user_editcount from... |
9 years ago |
| USE knwiki_p;
desc user;
select user_id, user_name, user_editcount from... |
9 years ago |
| USE knwiki_p;
desc user;
select user_id, user_name, user_editcount from... |
9 years ago |
| USE knwiki_p;
desc user;
select user_id, user_name from user where... |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_editcount >10000... |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_editcount >10000... |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_editcount >10000 asscending; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_editcount >10000; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_id <25; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_name = "HPNadig"; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_name = "Thejesh"; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_id < 10; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_id = 1; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_name Like "ಪ%"; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_name Like "P%"; |
9 years ago |
| USE knwiki_p;
desc user;
select * from user where user_name = "Pavanaja"; |
9 years ago |
| USE knwiki_p;
desc user; |
9 years ago |
| USE knwiki_p;
show tables; |
9 years ago |
| USE knwiki_p;
desc hitcounter;
select * from hitcounter; |
9 years ago |
| USE knwiki_p;
desc hitcounter; |
9 years ago |
| USE knwiki_p;
show tables ; |
9 years ago |
| USE knwiki_p;
select * from site_stats ; |
9 years ago |
| USE knwiki_p;
desc site_stats; |
9 years ago |
| USE knwiki_p;
select * site_stats ; |
9 years ago |
| USE knwiki_p;
desc site_stats ; |
9 years ago |
| USE knwiki_p;
Select Count(*) from site_stats ; |
9 years ago |
| USE knwiki_p;
Select Count(*) from site_stats where ss_active_users = 0; |
9 years ago |
| USE knwiki_p;
desc site_stats; |
9 years ago |
| USE knwiki_p;
show tables; |
9 years ago |
| USE knwiki_p;
Select Count(*) from page where page_namespace = 0;
Select... |
9 years ago |
| USE knwiki_p;
Select Count(*) from page where page_namespace = 0;
Select... |
9 years ago |
| USE knwiki_p;
Select Count(*) from page where page_namespace = 0;
Select... |
9 years ago |
