title: MySQL Workbench: Error in query (1064): Syntax error near 'VISIBLE' at line 1
body: <p>Any ideas why <code>VISIBLE</code> below is causing an issue?</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `setting` (
    `uuid` INT(10) NOT NULL,
    `type` VARCHAR(255) NOT NULL,
    `code` VARCHAR(255) NOT NULL COMMENT 'An unique name.',
    `value` MEDIUMTEXT NULL DEFAULT NULL,
    `comment` LONGTEXT NULL DEFAULT NULL,
    `created_on` INT UNSIGNED NOT NULL,
    `updated_on` INT UNSIGNED NOT NULL,
    PRIMARY KEY (`uuid`))
  ENGINE = MyISAM
  DEFAULT CHARACTER SET = utf8;
  
  CREATE UNIQUE INDEX `name_UNIQUE` ON `setting` (`code` ASC) VISIBLE;
  
  CREATE UNIQUE INDEX `uuid_UNIQUE` ON `setting` (`uuid` ASC) VISIBLE;
  </code></pre>
  
  <p>Errors:</p>
  
  <blockquote>
    <p>CREATE UNIQUE INDEX <code>name_UNIQUE</code> ON <code>setting</code> (<code>code</code> ASC) VISIBLE
    Error in query (1064): Syntax error near 'VISIBLE' at line 1</p>
    
    <p>CREATE UNIQUE INDEX <code>uuid_UNIQUE</code> ON <code>setting</code> (<code>uuid</code> ASC) VISIBLE
    Error in query (1064): Syntax error near 'VISIBLE' at line 1</p>
  </blockquote>
  
  <p>No error if I remove <code>VISIBLE</code> but <strong>MySQL Workbench 8.0.12</strong> auto generates that. How can I stop MySQL Workbench from doing that?</p>
  
  <p>My MySQL info in my Ubuntu 18.04:</p>
  
  <blockquote>
    <p>MySQL version: 5.7.23-0ubuntu0.18.04.1 through PHP extension MySQLi</p>
  </blockquote>