Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

生成的XML很棒,提一个小优化点 #93

Open
wanmudong opened this issue Aug 27, 2020 · 0 comments
Open

生成的XML很棒,提一个小优化点 #93

wanmudong opened this issue Aug 27, 2020 · 0 comments

Comments

@wanmudong
Copy link

目前生成的mapper.xml中insert语句使用的是 :INSERT INTO tablename(列名…) VALUES(列值);
但由于列名和列值都需要进行判断,导致动态sql中标签过多,一个插入语句就很多行,影响观感以及后续更新。
推荐使用:INSERT INTO tablename SET column_name1 = value1, column_name2 = value2,…;
这样判断数量可以减少一半,大大提升观感。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant