Chunk #565

Aus: Cheat-Sheet (Index: 1)

69 Tokens
Synced Status
« Vorheriger (#0) Nächster (#2) »

Taxonomie

Kategorie Basis-Queries
Pfad Basis-Queries > Aggregation > Datenbankabfragen
Heading-Pfad Cheat-Sheet > MCP-DB Cheat-Sheet > Basis-Queries > Aggregation (COUNT, AVG, etc.)

Entities

Name Typ
MySQL TECHNOLOGY
MCP-DB TECHNOLOGY
db_select SERVICE

Keywords

COUNT AVG Aggregation Database Query MCP-DB

Inhalt

Alt (mysql) Neu (MCP-DB)
mysql -u user -p ki_protokoll \
  -e "SELECT COUNT(*) as total,
      AVG(duration_ms) as avg_ms
      FROM protokoll"
db_select(
  "SELECT COUNT(*) as total,
   AVG(duration_ms) as avg_ms
   FROM protokoll",
  database="ki_protokoll"
)

Clean Content

Alt (mysql)
 Neu (MCP-DB)
 

 
 
```
`mysql -u user -p ki_protokoll \
 -e "SELECT COUNT(*) as total,
 AVG(duration_ms) as avg_ms
 FROM protokoll"`
```

 
```
`db_select(
 "SELECT COUNT(*) as total,
 AVG(duration_ms) as avg_ms
 FROM protokoll",
 database="ki_protokoll"
)`
```

Metadaten

Analysiert am20.12.2025 12:44:42
Analyse-Modellgemma3:4b-it-qat
Embedding-Modellmxbai-embed-large
Qdrant-ID8d0c7757-1833-437f-bd3f-3998207c3b3a
Erstellt20.12.2025 12:34:42
Aktualisiert20.12.2025 12:53:39