Home > database >  Consult the database for the same attribute
Consult the database for the same attribute

Time:10-18

Just said the same when notes properties such as the where dept in (XXX, XXX, XXX) behind said this is what I remember the sentence in a collection didn't see the XXX what is said is the content of the column name

CodePudding user response:

XXX, represents a specific value,

For example:
Select * from emp where the name (in 'zhang', 'bill', 'Cathy')

Equivalent to
Select * from emp where name='zhang' or name='bill' or name='Cathy'

CodePudding user response:

reference 1st floor selling fruit net reply:
XXX, represents a specific value,

For example:
Select * from emp where the name (in 'zhang', 'bill', 'Cathy')

Equivalent to
Select * from emp where name='zhang' or name='bill' or name='Cathy'

Thanks brother! I've got it!

CodePudding user response:

# 1 moderators explain very well, the original poster is ok and stick it

CodePudding user response:

Crying can only mobile node is not on the computer

CodePudding user response:

I take an examination of, you learn about the most basic of several SQL syntax,
Actually not much, just a few key words
Select
The from
Where
The order by
Group
Having
Etc., and seldom update, studied has been useful

CodePudding user response:

I learned that, just thinking slowly,,,
  • Related