USE wikidatawiki_p;
SELECT SUBSTR(user_name, 1, 1) AS initial, COUNT(*) AS... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(user_name, 1, 1) AS initial, COUNT(*) AS... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(user.user_name, 1, 1) AS initial,... |
6 years ago |
USE wikidatawiki_p;
SELECT user_initial.initial, HEX(user_initial.initial)... |
6 years ago |
USE wikidatawiki_p;
SELECT user_initial.initial, HEX(user_initial.initial)... |
6 years ago |
USE wikidatawiki_p;
SELECT initial, HEX(initial) AS initial_hex, count FROM... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(user.user_name, 1, 1) AS initial,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(user.user_name, 1, 1) AS initial,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(some_user.user_name, 1, 1) AS initial,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(some_user.user_name, 1, 1) AS initial,... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(user_name, 1, 1) AS initial, COUNT(*) AS... |
6 years ago |
USE wikidatawiki_p;
SELECT SUBSTR(user_name, 0, 1) AS initial, COUNT(*) AS... |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM user ORDER BY user_editcount DESC LIMIT 10; |
6 years ago |
USE wikidatawiki_p;
SELECT * FROM user LIMIT 10; |
6 years ago |
USE wikidatawiki_p;
SHOW TABLES; |
6 years ago |