MySQLã®InnoDBã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¯è¡ããã¯ããµãã¼ããã¦ãã¾ãããããOracleã¨åãæè¦ã§ã¢ããªã±ã¼ã·ã§ã³ãä½ã£ã¦ããã¨ãæãã¬ã¨ããã§ãããããã¯ã«åºããããã¨ãããã¾ããããã¯InnoDBã®ããã¯ç¯å²ãOracleãããå¾®å¦ã«åºãããã§ãã å®éã®ä¾ã§ç¢ºèªãã¦ã¿ã¾ãããã mysql> select * from t; +----+------+ | c1 | c2 | +----+------+ | 10 | a | | 15 | a | | 20 | a | | 25 | a | | 30 | a | | 35 | a | | 40 | a | | 45 | a | | 50 | a | +----+------+c1åã¯ä¸»ãã¼ã«ãªã£ã¦ãã¾ãã1ã¤ãã®ã»ãã·ã§ã³ã§ä»¥ä¸ã®SQLãå®è¡ãã¾ãã mysql> set tx_isolation = 'repeatable-r
{{#tags}}- {{label}}
{{/tags}}