When mybatis inserts a comma-containing value into mysql, the following error occurs: mybatismysql
An error is returned when mybatis inserts data such as "11, 22, 33" into mysql. The cause of the error is that I joined the SQL statement with the dollar sign. The correct method is to use # To check the difference between $ and # Of mybatis.
How to add an error in mysql using mybatis
--> Check --> does jdbc import classpath?
--> In addition, your SQL statement may be wrong.
------> Check here
Insert into picture p (p. picturename, p. filepath) values (# {picturename}, # {filepath })
------> Insert into table_name (column1, column2, column3,...) VALUES (value1, value2, value3 ,...)
-----------> What is p next to picture?
-----> Other questions are not found yet.
How can I write the SQL statement of MyBatis if the inserted object contains sub-objects? Very urgent. You can append a large number of scores.
<Insert id = "create" parameterType = "Teacher">
Insert into xstb_teacher (name,
StudentName)
VALUES (
# {Name, jdbcType = NVARCHAR },
# {Student. name, jdbcType = NVARCHAR}
)
</Insert>