# Database manipulation

**URL:** <https://community.influxdata.com/t/database-manipulation/14908>\
**Category:** Store\
**Created:** [June 19, 2020, 2:06pm UTC](https://community.influxdata.com/t/database-manipulation/14908 "2020-06-19T14:06:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Annonyme1](https://avatars.discourse-cdn.com/v4/letter/a/e9bcb4/32.png) [@Annonyme1](https://community.influxdata.com/u/Annonyme1)\
**Post date:** [June 19, 2020, 2:06pm UTC](https://community.influxdata.com/t/database-manipulation/14908/1 "2020-06-19T14:06:07Z")

</div>

How can i delete unwanted host from my influxdb !  
i tried show series where host =’…’  
then DROP SERIES WHERE HOST=’…’  
but 😃\> drop series where host=‘HAproxy2’

> show series where host=‘HAproxy2’  
> drop series where host=‘HAproxy2’  
> show series where host=‘HAproxy2’  
> show series where host=‘HAproxy2’  
> show series where host=‘HAproxy2’  
> key

cpu,cpu=cpu-total,host=HAproxy2  
cpu,cpu=cpu0,host=HAproxy2  
cpu,cpu=cpu1,host=HAproxy2  
disk,device=sda1,fstype=ext4,host=HAproxy2,mode=rw,path=/  
diskio,host=HAproxy2,name=loop0  
diskio,host=HAproxy2,name=loop1  
diskio,host=HAproxy2,name=loop2  
diskio,host=HAproxy2,name=loop3  
diskio,host=HAproxy2,name=loop4  
diskio,host=HAproxy2,name=sda  
diskio,host=HAproxy2,name=sda1  
diskio,host=HAproxy2,name=sda2  
diskio,host=HAproxy2,name=sda5  
kernel,host=HAproxy2  
mem,host=HAproxy2  
net,host=HAproxy2,interface=all  
processes,host=HAproxy2  
swap,host=HAproxy2  
system,host=HAproxy2

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [June 24, 2020, 6:42pm UTC](https://community.influxdata.com/t/database-manipulation/14908/2 "2020-06-24T18:42:44Z")

</div>

Hello @Annonyme1,  
I believe the full syntax is:

```auto
DROP SERIES FROM "your database" WHERE "host"='HAproxy2'

```

Does that work for you?  
🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/3X/2/f/2feb065bdfd5e4b7728243aa3b9192ad3e8447c1.png) [@system](https://community.influxdata.com/u/system)\
**Post date:** [July 1, 2020, 10:32am UTC](https://community.influxdata.com/t/database-manipulation/14908/3 "2020-07-01T10:32:03Z")

</div>

Closed on July 1, 2020, 10:32am UTC

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.
