Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Segnargsed
.
Toggle Highlighting
SQL
-- ceci est un commentaire USE frwiki_p; -- 876 bases dispos ! -- SHOW databases LIKE "%_p"; -- SHOW tables FROM "frwiki_p"; -- limiter les résultats -- langage en MAJ mais pas d'obigation -- LIMIT 10; -- SELECT * -- FROM user_groups -- LIMIT 5; -- DESCRIBE user_groups; -- SELECT ug_group,ug_user FROM user_groups -- LIMIT 5; -- SELECT ug_group,ug_user FROM user_groups -- WHERE ug_group='bureaucrat' AND ug_user < 1000 LIMIT 10; -- SELECT ug_group,ug_user FROM user_groups -- WHERE ug_group='bureaucrat' AND (ug_user < 1000 OR ug_user > 100000) LIMIT 10; -- SELECT ug_group,ug_user FROM user_groups -- WHERE ug_group in ('bureaucrat','checkuser') LIMIT 10; -- SELECT ug_group,ug_user FROM user_groups WHERE ug_group LIKE '%er%' LIMIT 10; -- SELECT DISTINCT ug_group,ug_user FROM user_groups WHERE ug_group LIKE '%er%' LIMIT 10; -- SELECT COUNT( DISTINCT ug_group) FROM user_groups; -- renommage du résultat -- SELECT COUNT(DISTINCT ug_group) AS NOMBRE FROM user_groups; -- KO SELECT ug_group AS GROUP, COUNT(ug_group) AS NOMBRE FROM user_groups GROUP BY ug_group HAVING NOMBRE > 100; -- SELECT ug_group AS group, COUNT(ug_group) AS nombre FROM user_group GROUP BY ug_group ORDER BY nombre ASC; -- SELECT ug_user, ug_group FROM user_groups WHERE ug_group IN ('trabswiki', 'confirled', 'flow-bot'); SELECT user.user_name, user_groups.ug_group FROM user_groups INNER JOIN user ON user_groups.ug_user = user.user_id WHERE ug_groups.ug_group IN ('trabswiki', 'confirled', 'flow-bot');
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...