---
title: "auto column, defined as a key"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/138978-auto-column-defined-as-a-key"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "richardjoha"
published: "2005-12-07T22:12:50.000Z"
updated: "2005-12-07T22:37:05.000Z"
replies: 1
views: 293
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/138978-auto-column-defined-as-a-key"
---

# auto column, defined as a key

## #1 — richardjoha, 2005-12-07T22:12Z

Fel

SQL-fråga :  

```
CREATE TABLE `nyheter` (

`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`writer` VARCHAR( 50 ) NOT NULL ,
`title` VARCHAR( 50 ) NOT NULL ,
`text` TEXT NOT NULL ,
`date` DATE DEFAULT '0000-00-00' NOT NULL 
)
```

MySQL sa: 

\#1075 - Incorrect table definition; There can only be one auto column and it must be defined as a key

Hur får jag auto kolumnen till en key?
php my admin är det som ska hantera.

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

## #2 — richardjoha, 2005-12-07T22:37Z

Löste det..

ändrade kolumnen ID till primär.

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/138978-auto-column-defined-as-a-key