mysql

[mika]

Hallo Leute!!

Erstelle in mysql mit dem MysqlAdministrator ein Table - bekomme aber IMMER nur Fehlermeldungen!! Warum??

Version: MySQL 5.0.45-Debian

CREATE TABLE WC.user (
  id INT  NOT NULL DEFAULT NULL AUTO_INCREMENT,
  name VARCHAR  NOT NULL,
  surname VARCHAR  NOT NULL,
  bday INT UNSIGNED NOT NULL,
  wert1 INT UNSIGNED NOT NULL,
  wert2 INT UNSIGNED NOT NULL,
  access INT UNSIGNED NOT NULL,
  PRIMARY KEY(id)
)
ENGINE = MYISAM;

ERROR? Was ist da falsch??

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,
  surname VARCHAR  NOT NULL,
  bday INT UNSIGNED NOT NULL,
  `vyea' at line 3 (errno: 1064)
Click 'Ignore' if you'd like to have this error ignored until the end of the script.

gruss