MySQL limitations

When using MySQL 5.1 Enterprise after many years of using other database products, such as Sybase, Infomix, DB2; I am facing what MySQL just does not do. For example, it can only generate an EXPLAIN query plan for SELECT queries.

What other things should I observe?

+5
source share
6 answers

You can take a look at the long list here: MySQL Gotchas

+7
source

Full external connection. But you can still make the right outer join with the outer join.

+4
source

, , , MySQL . ! , , int, ( ) .

MySQL JDBC , , ( OutOfMemory). , , :

Statement sx = c.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,java.sql.ResultSet.CONCUR_READ_ONLY);
sx.setFetchSize(Integer.MIN_VALUE);

, JDBC , , , ORM? , . , , ORM- - .

- , URL- JDBC. , .

+2

+1

. - . .

+1

- CHECK!

+1
source

All Articles