Shulou(Shulou.com)06/01 Report--

MySQL query statement SELECT, mainly using * to represent any field, can also write id,name,content, etc., data condition filtering is mainly between,and,or, WHERE,in,like,limit,not in and so on.

1, the usage of query statement SELECT

Select * from biao

2, the usage of data condition of query statement

The beginning of the where condition

And parallel relation

The relationship between or or

Between between and

Like fuzzy query

Limit limits the number of queries

What's in in?

Not in is not in what.

Article from (www.dc3688.com)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.