Get the App
SLTechnology News&Howtos  ›  Database  › 

Does the between and in the Mysql data query statement contain boundaries

Shulou Source: shulou.com Published: 2022-06-01 16:17:44 10月02日 Update

Between and contains boundary values in Mysql data query statements

You can use between in the sql statement of MySQL to limit the scope of a data, for example:

Select * from user where userId between 5 and 7

The user,userId range of query userId 5, 6 and 7 contains boundary values, which is the same as the following query:

Select * from user where userId > = 5 and userId =,

Tags: Boundaries scope queries data statements data queries no content places that is articles ways more conditions conclusions this is an experiment Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi MariaDB Shulou Tech Info NVidia macOS