xml文件中的代码:
<insert id="createView">
create view ${viewName} as select * from grid_user where "createDate"=CURRENT_DATE
</insert>
或者
<update id="createView">
create view ${viewName} as select * from grid_user where "createDate"=CURRENT_DATE
</update>
运行截图:
注:使用insert标签和update标签都可以,虽然会返回false,但是数据库中视图能创建成功。