If we want to support two different database syntax, can we only migrate to XML?

Can mybatis annotation define different databaseids. For example @Select(value = "SELECT count(1) from users" databaseId = "mysql") @Select(value = "SELECT count(*) from users" databaseId = "pgsql") int countSum();

Comment From: harawata

1466 is what you want, right?

Comment From: shootercheng

@harawata Thank you for your answer. We can use providercontext.getDatabaseId() to distinguish different syntax