| use knwiki_p;
Select * from page where page_namespace = 1 and... |
1 year ago |
| use tcywiki_p;
Select Count(*) from page where page_namespace = 0 and... |
2 years ago |
| use knwiki_p;
Select Count(*) from page where page_namespace = 0 and... |
6 years ago |
| use knwiki_p;
select count(*) from user where user_editcount > 5;
Select... |
6 years ago |
| use knwiki_p;
select count(*) from user where user_editcount > 5;
Select... |
7 years ago |
| use knwiki_p;
select count(*) from user where user_editcount > 5;
|
7 years ago |
| use knwiki_p;
select count(*) from user where user_editcount > 0;
|
7 years ago |
| use knwiki_p;
select count(*) from user where user_editcount > 5;
|
7 years ago |
| use knwiki_p;
select page_title, page_len from page where page_len < '6144'... |
7 years ago |
| use knwiki_p;
select page_title, page_len from page where page_len < '6144'... |
8 years ago |
| use knwiki_p;
select page_title, page_len from page where page_len < '6144'... |
8 years ago |
| use knwiki_p;
select page_title, page_len from page where page_len < '6144'... |
8 years ago |
| use knwiki_p;
select page_title, page_len from page where page_len < '6144'... |
8 years ago |
| use knwiki_p;
select page_title from page, page_len where page_len < '6144'... |
8 years ago |
| use knwiki_p;
show tables;
desc page;
|
8 years ago |
| use knwiki_p;
select page_title from page where page_len < '6144' and... |
8 years ago |
| use knwiki_p;
show tables;
|
8 years ago |
| show databases; |
8 years ago |
| use knwiki_p;
SELECT log_title, COUNT(*) FROM logging WHERE... |
8 years ago |
| use knwiki_p;
SELECT log_title, COUNT(*) FROM logging WHERE... |
8 years ago |
| use knwiki_p;
SELECT LEFT(log_timestamp, 6) as month, COUNT(*) FROM logging... |
8 years ago |
| use knwiki_p;
SELECT
page_namespace,
page_title,
page_len
FROM... |
8 years ago |
| use knwiki_p;
show tables;
desc user;
desc page;
desc revision;
|
8 years ago |
| use knwiki_p;
select count(*) from page where page_title like "ಪ%" and... |
8 years ago |
| use knwiki_p;
show tables;
desc user;
desc page;
|
8 years ago |
| use knwiki_p;
show tables;
desc user;
|
8 years ago |
| use knwiki_p;
select count(*) from page, revision where rev_page = page_id... |
8 years ago |
| use knwiki_p;
show tables;
desc revision;
|
8 years ago |
| use knwiki_p;
select * from user where user_name ="Pavanaja"; |
8 years ago |
| use knwiki_p;
show tables;
desc user;
DESCRIBE user_properties; |
8 years ago |
| use knwiki_p;
show tables;
DESCRIBE user_properties; |
8 years ago |
| use knwiki_p;
show tables;
DESCRIBE knwiki_p.page; |
8 years ago |
| use knwiki_p;
show tables; |
8 years ago |
| use knwiki_p;
desc pages; |
8 years ago |
| use knwiki_p;
select * from page where page_title like "ಅ%" limit 10;
|
8 years ago |
| use knwiki_p;
select * from page where page_title like "ಅ%" limit =10;
|
8 years ago |
| use knwiki_p;
show tables;
desc page; |
8 years ago |
| use knwiki_p;
show tables;
|
8 years ago |
| use knwiki_p;
select page_title from page where page_title like "'%";
|
8 years ago |
| use knwiki_p;
select page_title from page where page_title like "'%";
|
8 years ago |
| use knwiki_p;
select page_title from page where page_title < "z";
|
8 years ago |
| use knwiki_p;
show tables;
select page_title from page where page_title like "ಪ%"; |
8 years ago |
| use knwiki_p;
show tables;
select * from page_title where page_title like "ಪ%"; |
8 years ago |
| use knwiki_p;
show tables;
select * from page_title where page_title like "ಪ%"; |
8 years ago |
| use knwiki_p;
show tables;
select * from page_title where page_title like "ಪ%"; |
8 years ago |
| use knwiki_p;
show tables;
select * from page_title where page_title like "ಪ%"; |
8 years ago |
| use knwiki_p;
show tables;
desc page; |
8 years ago |
| use knwiki_p;
show tables;
|
8 years ago |
| use knwiki_p;
select * from user where user_name Like "ಪ%"; |
8 years ago |
| use knwiki_p;
select page_title where page_title like "ಪ%"; |
8 years ago |
| use knwiki_p;
Select Count(*) from page where page_namespace = 0 and... |
8 years ago |
| use knwiki_p;
Select Count(*) from page where page_namespace = 0 and... |
8 years ago |
| use orwiki;
Select Count(*) from page where page_namespace = 0 and... |
8 years ago |
| use knwiki;
Select Count(*) from page where page_namespace = 0 and... |
8 years ago |
| use knwiki;
show tables;
Select Count(*) from page where page_namespace = 0... |
8 years ago |
| use knwiki;
show tables;
Select Count(*) from page where page_namespace = 0... |
8 years ago |
| use knwiki;
show tables;
|
8 years ago |
| use knwiki;
show tables;
desc page; |
8 years ago |
| use knwiki;
show tables;
Select Count(*) from page where page_namespace = 0;
|
8 years ago |
| use knwiki;
show tables;
select * from page;
|
8 years ago |
| use knwiki;
show tables;
desc page;
|
8 years ago |
| use knwiki;
show tables;
|
8 years ago |
| use knwiki;
show tables;
desc user_properties;
|
8 years ago |
| use knwiki;
show tables;
|
8 years ago |
| use knwiki;
select * from user_properties;
|
8 years ago |
| use knwiki;
select * from user_properties;
|
8 years ago |
| use knwiki;
show columns from user_properties;
|
8 years ago |
| use knwiki;
show tables;
|
8 years ago |
