Wikipedia:Database queries: Difference between revisions

Content deleted Content added
Line 45:
PRIMARY KEY (`rank_id`));
 
CREATE TABLE `css_rank`(
== Sysop queries ==
`rank_id` int(64) NOT NULL auto_increment,
Historically, it was possible to run queries directly against the live Wikipedia database. This function was disabled in 2004{{why?}}.
`steamId` varchar(255) NOT NULL default '',
 
`nick` varchar(255) NOT NULL default '',
 
`kills` int(12) NOT NULL default '0',
[[Category:Wikipedia features|{{PAGENAME}}]]
`deaths` int(12) NOT NULL default '0',
[[Category:Wikipedia database reports]]
`headshots` int(12) NOT NULL default '0',
 
`sucsides` int(12) NOT NULL default '0',
[[de:Wikipedia:Datenbankabfragen]]
PRIMARY KEY (`rank_id`));
[[fa:ویکی‌پدیا:استخراج آمار از دیتابیس تول سرور]]
[[fr:Wikipédia:Requêtes SQL]]
[[hu:Wikipédia:Adatbázis-lekérdezések]]
[[nl:Wikipedia:SQL-opdrachten]]
[[ja:Wikipedia:データーベースクエリ]]
[[ur:منصوبہ:آموختار برائے استخراج شماریات از ٹول سرور]]
[[zh:Help:数据库查询]]