mysql--001

show databases; --- querying the database

Use database; --- switching databases

Show tables; --- query table

Desc table; --- view table structure

Add ---Insert into table(field 1, field 2,... ) ) Values (value) ;

Insert into table values ( value );-- insert all Columns

Change ---Update table set field = value where expr;

Update table set field = value ;--- modify all data !!!

Delete ---Delete from table where expr;

Check ---Select * from table;--- simplest query statement

Select expr from expr where expr;

==> columns are variables, variables can be evaluated,where is the expression, the value is true or false

mysql--001