A little summary after learning Mysql (Basics) _mysql

1. To operate the MySQL server at a command prompt, add system variables. (Computer-System Properties--environment variable--path)

2. Query the data in the data table;

Select Selection_list SELECT */columns

From Table_list to Table1/table2

where Primary_constraint

GROUP BY Grouping_columns

ORDER BY sorting_colomns desc Descending select * FROM table-ID desc;

Having Second_constraint

Limit count select * from table where ID limit 1, 4;

2 Common statistical functions: AVG (field), Sum (field), Count (field), Min (field),

Select SUM (field 2) as Alias, Field 1 from Table Group By field 1;

3 arithmetic, string, and logical operation constructs expression: SELECT * (price*0.8) as ' 80% ' from table; 80 percent