Also see:

http://dev.mysql.com/doc/refman/5.0/en/delete.html

 public MySQLDictionary() 
{
      
        platform = "MySQL";
        validationSQL = "SELECT NOW()";
        distinctCountColumnSeparator = ",";
        supportsDeferredConstraints = false;
        constraintNameMode = CONS_NAME_MID;
        supportsMultipleNontransactionalResultSets = false;
        requiresAliasForSubselect = true; // new versions
        requiresTargetForDelete = true;
        supportsSelectStartIndex = true;
        supportsSelectEndIndex = true;
        concatenateFunction = "CONCAT({0},{1})";
        maxTableNameLength = 64;
        maxColumnNameLength = 64;
        maxIndexNameLength = 64;
        maxConstraintNameLength = 64;
        maxIndexesPerTable = 32;
        schemaCase = SCHEMA_CASE_PRESERVE;
        supportsAutoAssign = true;
        lastGeneratedKeyQuery = "SELECT LAST_INSERT_ID()";
        autoAssignClause = "AUTO_INCREMENT";
        clobTypeName = "TEXT";
        longVarcharTypeName = "TEXT";
        longVarbinaryTypeName = "LONG VARBINARY";
        timestampTypeName = "DATETIME";
        fixedSizeTypeNameSet.addAll(Arrays.asList(new String[]{
            "BOOL", "LONG VARBINARY", "MEDIUMBLOB", "LONGBLOB",
            "TINYBLOB", "LONG VARCHAR", "MEDIUMTEXT", "LONGTEXT", "TEXT",
            "TINYTEXT", "DOUBLE PRECISION", "ENUM", "SET", "DATETIME",
        }));
        reservedWordSet.addAll(Arrays.asList(new String[]{
            "INT1", "INT2", "INT4", "FLOAT1", "FLOAT2", "FLOAT4",
            "AUTO_INCREMENT", "BINARY", "BLOB", "CHANGE", "ENUM", "INFILE",
            "LOAD", "MEDIUMINT", "OPTION", "OUTFILE", "REPLACE",
            "SET", "STARTING", "TEXT", "UNSIGNED", "ZEROFILL",
        }));
        // MySQL requires double-escape for strings
        searchStringEscape = "\\\\";
        typeModifierSet.addAll(Arrays.asList(new String[] { "UNSIGNED",
            "ZEROFILL" }));
}

 protected  void appendSelectRange(SQLBuffer buf,
    long start,
    long end,
    boolean subselect) 
{
        buf.append(" LIMIT ").appendValue(start).append(", ");
        if (end == Long.MAX_VALUE)
            buf.appendValue(Long.MAX_VALUE);
        else
            buf.appendValue(end - start);
}

 public  void connectedConfiguration(Connection conn) throws SQLException 
{
        super.connectedConfiguration(conn);
        DatabaseMetaData metaData = conn.getMetaData();
        // The product version looks like 4.1.3-nt
        String productVersion = metaData.getDatabaseProductVersion();
        // The driver version looks like mysql-connector-java-3.1.11 (...)
        String driverVersion = metaData.getDriverVersion();
        try {
            int[] versions = getMajorMinorVersions(productVersion);
            int maj = versions[0];
            int min = versions[1];
            if (maj <  4 || (maj == 4 && min <  1)) {
                supportsSubselect = false;
                allowsAliasInBulkClause = false;
            }
            versions = getMajorMinorVersions(driverVersion);
            maj = versions[0];
            if (maj <  5) {
                driverDeserializesBlobs = true;
            }
        } catch (IllegalArgumentException e) {
            // we don't understand the version format.
            // That is ok. We just take the default values.
        }
}

 public String[] getAddPrimaryKeySQL(PrimaryKey pk) 
{
        String[] sql = super.getAddPrimaryKeySQL(pk);
        // mysql requires that a column be declared NOT NULL before
        // it can be made a primary key.
        Column[] cols = pk.getColumns();
        String[] ret = new String[cols.length + sql.length];
        for (int i = 0; i <  cols.length; i++) {
            ret[i] = "ALTER TABLE " + getFullName(cols[i].getTable(), false)
                + " CHANGE " + cols[i].getName()
                + " " + cols[i].getName() // name twice
                + " " + getTypeName(cols[i]) + " NOT NULL";
        }
        System.arraycopy(sql, 0, ret, cols.length, sql.length);
        return ret;
}

 public Object getBlobObject(ResultSet rs,
    int column,
    JDBCStore store) throws SQLException 
{
        // if the user has set a get-blob strategy explicitly or the driver
        // does not automatically deserialize, delegate to super
        if (useGetBytesForBlobs || useGetObjectForBlobs
            || !driverDeserializesBlobs)
            return super.getBlobObject(rs, column, store);
        // most mysql drivers deserialize on getObject
        return rs.getObject(column);
}

 public String[] getCreateTableSQL(Table table) 
{
        String[] sql = super.getCreateTableSQL(table);
        if (!StringUtils.isEmpty(tableType))
            sql[0] = sql[0] + " TYPE = " + tableType;
        return sql;
}

 public String[] getDeleteTableContentsSQL(Table[] tables) 
{
        // mysql  >= 4 supports more-optimal delete syntax
        if (!optimizeMultiTableDeletes)
            return super.getDeleteTableContentsSQL(tables);
        else {
            StringBuffer buf = new StringBuffer(tables.length * 8);
            buf.append("DELETE FROM ");
            for (int i = 0; i <  tables.length; i++) {
                buf.append(tables[i].getFullName());
                if (i <  tables.length - 1)
                    buf.append(", ");
            }
            return new String[] { buf.toString() };
        }
}

 public String[] getDropIndexSQL(Index index) 
{
        return new String[]{ "DROP INDEX " + getFullName(index) + " ON "
            + getFullName(index.getTable(), false) };
}

 protected String getForeignKeyConstraintSQL(ForeignKey fk) 
{
        // mysql does not support composite foreign keys
        if (fk.getColumns().length  > 1)
            return null;
        return super.getForeignKeyConstraintSQL(fk);
}

 public int getPreferredType(int type) 
{
        if (type == Types.CLOB && !useClobs)
            return Types.LONGVARCHAR;
        return super.getPreferredType(type);
}

 protected Column newColumn(ResultSet colMeta) throws SQLException 
{
        Column col = super.newColumn(colMeta);
        if (col.isNotNull() && "0".equals(col.getDefaultString()))
            col.setDefaultString(null);
        return col;
}