摘要: mysql临时表代替in的写法 $sql = "create temporary table tmp(id int(4) primary key)"; $this->commonexecute($sql); $sql = "insert into tmp values (23), (433)"; $ 阅读全文
posted @ 2021-07-06 11:16 newmiracle宇宙 阅读(196) 评论(0) 推荐(0) 编辑
摘要: mysql临时表进行批量更新 $sql = "create temporary table tmp(id int(4) primary key,dr varchar(50))"; $this->commonexecute($sql); $sql = "insert into tmp values ( 阅读全文
posted @ 2021-07-06 11:01 newmiracle宇宙 阅读(651) 评论(0) 推荐(0) 编辑