Wiki:Dokumentation/2025-08-20: Unterschied zwischen den Versionen

Version vom 20. August 2025, 13:07 Uhr

sqlquery -en genwiki -qp queries.yaml -qn user_count -f mediawiki

select count(*) from user;


count(*)
17403

sqlquery -en genwiki -qp queries.yaml -qn table_count --params table=image -f mediawiki

select count(*) from image;


count(*)
91394

@@ Zeile 1: / Zeile 1: @@
 <source lang='bash'>
 sqlquery -en genwiki -qp queries.yaml -qn user_count -f mediawiki
@@ Zeile 18: / Zeile 19: @@
 |-
 | align="right"|      17403
+|}
+sqlquery -en genwiki -qp queries.yaml -qn table_count  --params table=image -f mediawiki
+== table_count ==
+=== query ===
+<source lang='sql'>
+select count(*) from image;
+</source>
+=== result ===
+{| class="wikitable" style="text-align: left;"
+|+ <!-- caption -->
+|-
+! align="right"|   count(*)
+|-
+| align="right"|      91394
 |}