/* alle Felder der Tabelle user in der de.wikipedia */
use dewiki_p;
select... |
6 years ago |
/* user_id zum user_name in der deutschsprachigen WP ermitteln */
use... |
6 years ago |
/* hoechste user_id im dewiki */
use dewiki_p;
select user_name, user_id... |
6 years ago |
use dewiki_p;
select user_name, user_id from user
order by user_id desc limit 1
|
6 years ago |
use dewiki_p;
select user_name, user_id from user
order by user_id desc limit 10
|
6 years ago |
use dewiki_p;
select user_name, user_id from user
where user_name =... |
6 years ago |
use dewiki_p;
select user_name, user_id from user
where user_name = 'Michael32710'
|
6 years ago |
use dewiki_p;
select * from user limit 10 |
6 years ago |
select * from user limit 10 |
6 years ago |
select * from user top 10 |
6 years ago |