---
title: "Fel på enkel SP i mysql"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/164504-fel-på-enkel-sp-i-mysql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Travoni"
published: "2007-09-14T08:17:33.000Z"
updated: "2007-09-14T08:20:26.000Z"
replies: 1
views: 365
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/164504-fel-på-enkel-sp-i-mysql"
---

# Fel på enkel SP i mysql

## #1 — Travoni, 2007-09-14T08:17Z

```
CREATE PROCEDURE suv_set(guid varchar(40)) 
BEGIN
INSERT INTO UploadValider (suv_guid,suv_datetime) VALUES(guid,now());
DELETE FROM UploadValider WHERE suv_datetime < SUBDATE(now(), INTERVAL 30 minute)
END;
```

Fel får jag på denna rad: DELETE FROM UploadValider WHERE suv_datetime \< SUBDATE(now(), INTERVAL 30 minute)

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

## #2 — Travoni, 2007-09-14T08:20Z

DELETE FROM UploadValider WHERE suv_datetime \< SUBDATE(now(), INTERVAL 30 minute);;;;;;;;;;;;;;;; ;)

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/164504-fel-på-enkel-sp-i-mysql