sql
Tonal-all
这个作者很懒,什么都没留下…
展开
-
mybatis 批量插入list<map<String,String>>
原文需求:对于每一行,uid列指定不变,其他3列由list<map<String,String>>指定。 void insert(@Param("uid")String uid,@Param("data") List<Map<String,String>> data);<insert id="insert"> insert into table (uid,mdata0,data1,data2) values原创 2021-08-04 15:27:49 · 1093 阅读 · 0 评论 -
syntax to use near ‘identified by “password“‘ at line 1
ERROR 1064 (42000): 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 ‘identified by “password”’ at line 1在MySQL中对外开启远程访问时报错原语句grant all privileges on *.* to 'root'@'*.*.原创 2021-07-07 16:57:06 · 2983 阅读 · 1 评论