理解sql语句 [英] understanding sql statements

问题描述

我不知道什么是sql语句意味着任何一个exaplain它





请注意

i don't know what is that sql statement mean any one exaplain it


note that

QS_BUILD_CREATEUPGRADE

= 5

=5

IF (proc_type='".QS_BUILD_CREATEUPGRADE."' , building_id <> 25 AND building_id <> 26, 1)

它是mysql

it's mysql

推荐答案

QS_BUILD_CREATEUPGRADE 是什么：该代码无关紧要将它的名称视为字符串。

看起来它将 proc_type 列中的值与字符串值进行比较：

It doesn't matter what QS_BUILD_CREATEUPGRADE is: that code treats it's name as a string.
It looks like it compares the value in the proc_type column with the string value:

".QS_BUILD_CREATEUPGRADE."

但它看起来没有我认识的SQL IF函数或语句：我怀疑这不是SQL而是一些奇怪的处理器，它们被提供给/来自SQL



检查你从哪里得到代码。

but it looks like no SQL IF function or statement I recognize: I suspect that isn't SQL but some odd processor which feeds to / from SQL

Check where you got the code from.

这篇关于理解sql语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！