MySQL Search Select Basic introduction

1. Query Features:
   

   Which table data do you look for?

   Which columns are checked?

   SELECT * FROM class-----to query data for all rows and columns

   * represents all columns, the table name does not add a where condition, then all rows are selected, so all rows and columns are taken

2. Cases:

   Experiment One:

   Take part of the column, all lines, take the names and wages of everyone

   Mysql> select Sname,salary from class;

   All the columns of the man who checked id>10.

   Mysql> SELECT * from class where id>10;

Experiment Two:

Take partial row partial column

The person who takes the id<10, takes his name and the rice supplement

Mysql> Select Sname,fanbu from class where id<10;

After the where is considered an expression and the expression is true, the row is taken out

These are the most basic queries, followed by more complex, accurate query methods

This article from "Unchanged Time" blog, reprint please contact the author!