---
title: "Radera poster från en MySQL-databas"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/75596-radera-poster-från-en-mysql-databas"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Christoffer"
published: "2003-05-01T13:04:24.000Z"
updated: "2003-05-01T15:59:30.000Z"
replies: 2
views: 305
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/75596-radera-poster-från-en-mysql-databas"
---

# Radera poster från en MySQL-databas

## #1 — Christoffer, 2003-05-01T13:04Z

Följande kod är till en Access-databas:

\<!-- #include file="adovbs.inc" --\>

\<%
Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "driver={Microsoft Access Driver (\*.mdb)};dbq=" & Server.MapPath("mail.mdb")&";"

Set RecSet = Server.CreateObject("ADODB.Recordset")

Radera = "Select \* From mail Where ID=" &Request.QueryString("radera")
RecSet.Open Radera, Connect, adOpenStatic, adLockOptimistic

	RecSet.Delete

	RecSet.Update
	RecSet.Close

Connect.close
	Set RecSet = nothing
	Set Connect = nothing

Response.Redirect "brevladan.asp"

%\>

Hur göra för att få koden till MySQL?

Tacksam för svar.

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

## #2 — K@llen, 2003-05-01T15:57Z

```
sql = "delete from mail where ID=" & Request.QueryString("radera") 
Connect.execute(sql),,128

Response.Redirect "brevladan.asp"
```

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

## #3 — Boma, 2003-05-01T15:59Z

Set Conn = Server.CreateObject("ADODB.Connection") 
Conn.Open "Driver={MySQL ODBC 3.51 Driver};Server=xxxx;Database=xxxx;UID=xxxx;PWD=xxxx"

sql = "delete From mail Where ID=" & Request.QueryString("radera") 

Conn.Execute (sql) ,,128

Mvh

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/75596-radera-poster-från-en-mysql-databas