MySql 添加表时出错

Question

这是我尝试执行的 SQL 查询，但失败并出现以下错误:

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, passhash VARCHAR NOT NULL, permission TINYINT NOT NULL DEFAULT' at line 3:

这是查询:

DROP TABLE IF EXISTS `Maestros`;

CREATE TABLE `Maestros` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `nombre` VARCHAR NOT NULL,
  `passhash` VARCHAR NOT NULL,
  `permission` TINYINT NOT NULL DEFAULT 0,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `activo` TINYINT NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
KEY (`passhash`)
) COMMENT 'Tabla que contiene la informacion de los maestros';

Answer 1

varchar 应具有与其关联的长度，并且只能有一个具有默认值的 TimeStamp:

CREATE TABLE `Maestros` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `nombre` VARCHAR(255) NOT NULL,
  `passhash` VARCHAR(255) NOT NULL,
  `permission` TINYINT NOT NULL DEFAULT 0,
  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` TIMESTAMP,
  `activo` TINYINT NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
KEY (`passhash`)
) COMMENT 'Tabla que contiene la informacion de los maestros';

Here是一个 SQL Fiddle。