---
title: "DELETE"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/125973-delete"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "fredrik99"
published: "2005-04-08T17:32:55.000Z"
updated: "2005-04-08T17:43:22.000Z"
replies: 1
views: 221
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/125973-delete"
---

# DELETE

## #1 — fredrik99, 2005-04-08T17:32Z

Får följande fel msg med nedanstående kod, vad är snett? (mySQL)

```
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 
You have an error in your SQL syntax. Check the manual that 
corresponds to your MySQL server version for the right syntax to use near '* FROM tblPage WHERE Page_ID = 440' at line 1
```

```
conn.execute("DELETE * FROM tblPage WHERE Page_ID = " & pID & ";")
```

Permalänk: https://www.webforum.nu/p/125973

## #2 — LarsG, 2005-04-08T17:43Z

```
conn.execute "DELETE FROM tblPage WHERE Page_ID = " & pID
```

Permalänk: https://www.webforum.nu/p/1589392

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/125973-delete