SQL Error

[Anon]

I dont see whats wrong with my sql but if someone could help me find the error it would be great. Heres the code

SQL-query :

CREATE TABLE news (author VARCHAR NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, message TEXT NOT NULL, title VARCHAR NOT NULL, PRIMARY KEY (author), INDEX (author, id), UNIQUE (id))

MySQL said:

You have an error in your SQL syntax near 'NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, messag' at line 1

[mrseq]

First of all you try to create two primary keys (author and id) which is impossible.

Furthermore values in VARCHAR columns are variable-length strings - but you have to define a maximum length for VARCHARs, e.g.:
author VARCHAR(50). That means AUTHOR-values can not exceed 50 characters. A VARCHAR can have any length between 1 and 255 characters.

So your correct SQL-Query could look like this:

CREATE TABLE news (author VARCHAR(50) NOT NULL, date DATE NOT NULL, id INT NOT NULL AUTO_INCREMENT,
message TEXT NOT NULL, title VARCHAR(50) NOT NULL, PRIMARY KEY (author), INDEX (author, id),
UNIQUE (id)) ;

Hope this helps you.

[Anon]

Hi,

You can create primary key for two fields to a table stated below and I suggest that create sequence for id column and insert nxtval method of sequence number into id column while inserting rows into a table

CREATE TABLE news
(author VARCHAR(50) NOT NULL,
date DATE NOT NULL,
id INT NOT NULL,
message VARCHAR(50) NOT NULL,
title VARCHAR(50) NOT NULL,
PRIMARY KEY (author,id))

Bye