Mybatis出现You have an error in your SQL syntax； check the manual that corresponds to your MySQL....

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table1111'
        (  'name' , 'age' )
        VALUES
        (  '张三' , '12' at line 1
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: INSERT INTO ?         (  ? , ? )         VALUES         (  ? , ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table1111'
        (  'name' , 'age' )
        VALUES
        (  '张三' , '12' at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table1111'
        (  'name' , 'age' )
        VALUES
        (  '张三' , '12' at line 1

今天出现这个问题,折磨了我一下午,先看代码

void saveTable(@Param("model") List<Object> model, @Param("fileTableName") String fileTableName, @Param("tableOfList") List<DataTableDTO> tableOfList);

<insert id="saveTable">
        INSERT INTO #{fileTableName}
        (<foreach collection="tableOfList" item="DataTableDTO" separator=","> #{DataTableDTO.eName} </foreach>)
        VALUES
        (<foreach collection="model" item="item" separator=","> "#{item}" </foreach>)
 </insert>

如果把sql放到执行器是没有错的,这里是因为在传参时我前面添加的是"#",我向来以为的都是写"#“就行,根本没有考虑是这个符号的原因,将”#“换成”$"就可以完美解决,至于区别,使用场景自行百度
本人代码不精,有错误的地方欢迎指出来,共同学习