Swallow photography course

Query statement: select * from table where "hobby" not like "%photography%"

The premise of this statement is that all data exists in the created data table, "*" means to query all columns, table is the name of the table you created, "hobby" is an attribute column, and its contents are all hobbies.

In database operation, query operation is the most commonly used. When querying data, query the data in the database according to different requirements and conditions, and return the results. The specification of database basic query statement is: select a region from the table name.

Extended data

Fuzzy query: select * from table name, where the column name is similar to "%Chinese%";

Combined query: select different column names from the condition table names;

Range query: select * from table name, where the column name is between "a" and "b";

Multi-condition query: select * from table name, where column name =' a' or column name =' b'

Baidu Encyclopedia-Select ()