USE ruwiki_p;
select * from user_properties
group by up_property |
3 years ago |
USE ruwiki_p;
select up_property from user_properties
group by up_property |
3 years ago |
USE ruwiki_p;
select * from user_properties
where up_property like... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 2000369
limit 100 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 2000369
limit 100 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 2000000 and... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 2000682
limit 100 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 2000550
limit 100 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 2000309
limit 100 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 2000309 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 2000000
limit 10 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 3000000
limit 10 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 10000000
limit 10 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 1000000
limit 10 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user > 100000
limit 10 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 1 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property = "gender"
limit 10 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property = "gender" |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_user = 113 |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like... |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like "%disable%" |
3 years ago |
USE ruwiki_p;
select * from user_properties
WHERE up_property like "disable" |
3 years ago |
USE ruwiki_p;
select * from user_properties
limit 5 |
3 years ago |
USE ruwiki_p;
describe user_properties |
3 years ago |
USE ruwiki_p;
describe revision |
3 years ago |
USE ruwiki_p;
SHOW TABLES revision |
3 years ago |
USE ruwiki_p;
SHOW TABLES user_properties |
3 years ago |