dringend hilfe bitte! fehler beim tabelle erstellen im datenbank

[sakina]

hallo,

so siehts aus:

Fehler

SQL-Befehl:

CREATE TABLE eth.hourtest (
id INT NOT NULL ,
from TIME NOT NULL ,
until TIME NOT NULL ,
reason VARCHAR NOT NULL ,
date DATE NOT NULL
) ENGINE = MYISAM

MySQL meldet:
#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 'NOT NULL, date DATE NOT NULL) ENGINE = MyISAM' at line 1

ich brauch dringend eure hilfe, danke im voraus

lg,
sakina

[MudGuard]

Hi,

reason VARCHAR NOT NULL ,
date DATE NOT NULL

MySQL meldet:
#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 'NOT NULL, date DATE NOT NULL) ENGINE = MyISAM' at line 1

Die Angabe der Maximallänge für VARCHAR fehlt.

cu,
Andreas

[sakina]

Hi,

reason VARCHAR NOT NULL ,
date DATE NOT NULL

MySQL meldet:
#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 'NOT NULL, date DATE NOT NULL) ENGINE = MyISAM' at line 1

Die Angabe der Maximallänge für VARCHAR fehlt.

cu,
Andreas

vielen dank :)