Home > Backend Development > PHP Tutorial > UNION 查询 语句经常弄出裹脚布.解决方案

UNION 查询 语句经常弄出裹脚布.解决方案

WBOY
Release: 2016-06-13 10:20:26
Original
761 people have browsed it

UNION 查询 语句经常弄出裹脚布...
两个表union 再合计,字段多一点.
格式化一下SQL语句 行数87...
我擦~ 好在是用代码生成的.

不过觉得SQL蛮有意思.

------解决方案--------------------
要让对应的列属性一致,当然是程序生成的好些
------解决方案--------------------
貌似见过1500+行的SQL 表示压力好大
------解决方案--------------------
复杂点的统计,写出来。过几天都不认他了
------解决方案--------------------
如果想封装,可以用php函数封装一层,来操作数据库。有没有必要就不知道了
------解决方案--------------------
怎么会那么多字段啊?
------解决方案--------------------
.....搞那么多字段....

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template