How to replace table name with parameter value while using Spring Data JPA nativeQuery

Question

like this:

public interface XXXRepository extends CrudRepository<XXX, Integer> {
@Query(value = "select * from ?1 where ...", nativeQuery = true)
List<XXX> findByXXX(String tableName, ...);}

It gives MYSQL syntax error with upon codes. The syntax error shows that the table name in the SQL is surrounded with "'".

Answer 1

This is not possible. Parameters are only allowed in the where clause.