Executing SQL script in server
ERROR: Error 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 'VISIBLE)
ENGINE = InnoDB' at line 10
SQL Code:
-- -----------------------------------------------------
-- Table `php_training`.`Users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `php_training`.`Users` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT 'รหัสผู้ใช้',
`Usersname` VARCHAR(45) NOT NULL COMMENT 'ไอดี',
`password` VARCHAR(45) NOT NULL COMMENT 'รหัสผ่าน',
`last_login` DATETIME NULL COMMENT 'ล็อดอินครั้งสุดท้าย',
PRIMARY KEY (`id`),
UNIQUE INDEX `Usersname_UNIQUE` (`Usersname` ASC) VISIBLE)
ENGINE = InnoDB

SQL script execution finished: statements: 5 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch

นี่ส่วนตัวโค้สครับที่my sql workbenchแปลงมาให้ไม่รู้ต้องแก้syntaxตรงไหน
-- -----------------------------------------------------
-- Schema php_training
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `php_training` DEFAULT CHARACTER SET utf8 ;
USE `php_training` ;

-- -----------------------------------------------------
-- Table `php_training`.`Users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `php_training`.`Users` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT 'รหัสผู้ใช้',
`Usersname` VARCHAR(45) NOT NULL COMMENT 'ไอดี',
`password` VARCHAR(45) NOT NULL COMMENT 'รหัสผ่าน',
`last_login` DATETIME NULL COMMENT 'ล็อดอินครั้งสุดท้าย',
PRIMARY KEY (`id`),
UNIQUE INDEX `Usersname_UNIQUE` (`Usersname` ASC) VISIBLE)
ENGINE = InnoDB;