SELECT up_property, COUNT(up_user)
FROM user_properties
GROUP BY up_property
|
4 years ago |
SELECT COUNT(up_user)
FROM user_properties
|
4 years ago |
SELECT COUNT(DISTINCT up_user)
FROM user_properties
|
4 years ago |
SELECT COUNT(DISTINCT up_uesr)
FROM user_properties
|
4 years ago |
SELECT *
FROM user_properties
WHERE up_property = 'fancysig'
LIMIT 10
|
4 years ago |
SELECT *
FROM user_properties
WHERE up_property = 'fancysig'
LIMIT 10
|
4 years ago |
SELECT *
FROM user_properties
WHERE up_property = 'fancysig'
|
4 years ago |
SELECT DISTINCT up_property
FROM user_properties
|
4 years ago |
SELECT *
FROM user_properties
WHERE up_property != "disablemail"
#WHERE... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property = "echo-notifications-blacklist"
|
4 years ago |
SELECT *
FROM user_properties
#WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
WHERE up_property =... |
4 years ago |
SELECT *
FROM user_properties
LIMIT 5 |
4 years ago |
SELECT *
FROM user_properties
WHERE year = '2020' |
4 years ago |
show tables; |
4 years ago |
DESCRIBE enwiki_p; |
4 years ago |
DESCRIBE enwiki_p |
4 years ago |
show tabels; |
4 years ago |
use enwiki_p; |
4 years ago |
show databases; |
4 years ago |