-

misc

  add an index on a table: ALTER TABLE mytable ADD UNIQUE INDEX code(code);