Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to achieve query operation in mysql, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1. Select all records

Select * from table_name

Where * represents all the fields in the table.

2. Query records that are not duplicated

Use the keyword distinct

Select distinct field name from table name

3. Conditional query

Use the keyword where

Select * from table name where condition

The condition after where is a comparison of fields. You can use =, >, =,

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.