code: @Override
      public MySQLDatabase setSequence(final Connection _con,
                                       final String _name,
                                       final long _value)
          throws SQLException
      {
          final String name = _name.toLowerCase();
          final String lockCmd = new StringBuilder()
                  .append("LOCK TABLES `").append(MySQLDatabase.PREFIX_SEQUENCE).append(name)
                  .append("` WRITE")
                  .toString();
          final String deleteCmd = new StringBuilder()
                  .append("DELETE FROM `").append(MySQLDatabase.PREFIX_SEQUENCE).append(name).append("`")
                  .toString();
          final String alterCmd = new StringBuilder()
                  .append("ALTER TABLE `").append(MySQLDatabase.PREFIX_SEQUENCE).append(name)
                  .append("` AUTO_INCREMENT=").append(_value - 1)
                  .toString();
          final String insertCmd = new StringBuilder()
                  .append("INSERT INTO `").append(MySQLDatabase.PREFIX_SEQUENCE).append(name)
                  .append("` VALUES ()")
                  .toString();
          final String unlockCmd = new StringBuilder()
                  .append("UNLOCK TABLES")
                  .toString();
  
          final Statement stmt = _con.createStatement();
          try {
              stmt.executeUpdate(lockCmd);
              stmt.executeUpdate(deleteCmd);
              stmt.executeUpdate(alterCmd);
              stmt.executeUpdate(insertCmd);
              stmt.executeUpdate(unlockCmd);
          } finally {
              stmt.close();
          }
          return this;
      }
docs: Defines new <code>_value</code> for sequence <code>_name</code>. Because
  in MySQL the sequences are simulated and the values from fetched
  sequence numbers are not deleted, all existing values in the table are
  first deleted (to be sure that the sequence could be reseted to already
  fetched numbers). After the new starting value is defined a first auto
  generated value is fetched from the database so that this value is also
  stored if the MySQL database is restarted.
  
  @param _con          SQL connection
  @param _name         name of the sequence
  @param _value        new value of the sequence
  @return this instance
  @throws SQLException if new number of the sequence could not be defined
  for the table
  @see #PREFIX_SEQUENCE