mysql
PhperX
这个作者很懒,什么都没留下…
展开
-
Allowed memory size of xxxxxxxxxx bytes exhausted (tried to allocate 8192 bytes)-PHP内存溢出问题
Allowed memory size of xxxxxxxxxx bytes exhausted (tried to allocate 8192 bytes)-PHP内存溢出问题php程序在执行几万条的数据查询,插入,更新时,报错Allowed memory size of 2147483648 bytes exhausted (tried to allocate 8192 bytes),错误原因:php内存溢出:程序运行所需的内存,超出了配置(php.ini)限制。解决方式:直接在被调用方法开原创 2021-04-16 16:16:37 · 751 阅读 · 0 评论 -
MYSQL查询两张表并集
两张表都有的以及某一张表独有的数据,并剔除重复数据摘要:left join union right joinSELECT a,id a.name b.age from tablea as a LEFT JOIN tableb as b on a.id=b.id UNIONSELECT a,id a.name b.age from tablea as a RIGHT JOIN tableb as b on a.id=b.id; ...原创 2021-04-02 15:24:21 · 2032 阅读 · 0 评论