Hola, utilizo PHPMyAdmin y cuando intento crear esta tabla:
CREATE TABLE `Usuarios` (`nick` VARCHAR(12) NOT NULL, `contraseña` VARCHAR(20) NOT NULL, `power` VARCHAR(20) NOT NULL, `email` VARCHAR(50) NOT NULL, `nombre` VARCHAR(20) NOT NULL, `apellido` VARCHAR(20) NOT NULL, `nacimiento` DATE NOT NULL, `alta` DATE NOT NULL, `descripcion` VARCHAR NOT NULL, `elinks` INT UNSIGNED ZEROFILL NOT NULL, `juegos` INT UNSIGNED ZEROFILL NOT NULL, `emusica` INT UNSIGNED ZEROFILL NOT NULL, `esoft` INT UNSIGNED ZEROFILL NOT NULL, `ip` VARCHAR NOT NULL, `comentarios` VARCHAR NOT NULL, `post` INT UNSIGNED ZEROFILL NOT NULL, `id` INT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEY, UNIQUE (`nick`, `email`)) COMMENT = 'Tabla de Usuarios'
Me da éste error:
You have an error in your SQL syntax near 'NOT NULL, `elinks` INT UNSIGNED ZEROFILL NOT NULL, `juegos` INT UNSIGNED ZEROFIL' at line 1
y digo yo...si lo hago con el PHPmyadmin, xq me da un error asi?