In mysql, and means "and", which is used to combine two or more conditions in the WHERE substatement; when using the and keyword, records that meet all conditions will be returned. If any of the conditions are not met, such records will be excluded.
The operating environment of this tutorial: windows7 system, mysql8.0.22 version, Dell G3 computer.
What does and mean in mysql
And in mysql can combine two or more conditions in the WHERE substatement.
When using the and keyword:
needs to meet all conditions, and such records will be queried.
If any of the conditions are not met, such records will be excluded.
Example:
SELECT * FROM cs_user WHERE age >= 18 AND age <= 20
Recommended learning:mysql video tutorial
The above is the detailed content of What does and mean in mysql. For more information, please follow other related articles on the PHP Chinese website!