---
title: "timstamp problem"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/145935-timstamp-problem"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "dea"
published: "2006-04-24T09:15:15.000Z"
updated: "2006-04-24T09:26:01.000Z"
replies: 1
views: 445
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/145935-timstamp-problem"
---

# timstamp problem

## #1 — dea, 2006-04-24T09:15Z

ska lägga till en tabell i min databas (MySql) så här:

```
CREATE TABLE `photos` (
  `photo_id` int(11) NOT NULL auto_increment,
  `category_id` int(11) NOT NULL,
  `day_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `day_taken` date default NULL,
  `filename` varchar(255) NOT NULL,
  PRIMARY KEY  (`photo_id`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM
```

men jag får ett felmeddelande som lyder:

```
[red]#1064 - 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 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `day_taken` d[/red]
```

Jag trodde jag hade MySql 4.1 men det visade sig att det var 4.0.24.

Hur ändrar jag timestamp så att det fungerar till 4.0.24?

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

## #2 — LarsG, 2006-04-24T09:26Z

```
CREATE TABLE photos (
  photo_id int NOT NULL auto_increment,
  category_id int NOT NULL,
  day_added timestamp ,
  day_taken date,
  filename varchar(255) NOT NULL,
  PRIMARY KEY  (photo_id),
  KEY category_id (category_id)
) ENGINE=MyISAM
```

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/145935-timstamp-problem