<1> Understand the DB and DBMS
DBMS receives to the request of the SQL code and translate these requests into various operations on the table in the database
<2> To understand the SQL (structured query language)
(1) the SQL language
Data, data definition language (object)
, data manipulation language (mainly aimed at the table)
, data query language (single or multiple tables)
(data access, data control language)
(2) the SQL language commands [add and delete]
DDL,
, the create
The alter,
The drop,
DML,
Insert,
The update,
Delete,
DQL,
, select
DCL,
Grant,
Revoke,
<3> Understand the difference between Dbeaver/MySQL/SQL with contact
· Dbeaver client (graphical interface) to connect the corresponding database, you need to install MySQL to connect first
MySQL is a database management software, used to save data
SQL is a database operation grammar
, in Dbeaver writing SQL code to the data stored in the MySQL database operation

CodePudding user response:

Thanks for sharing, it is recommended that the blog

CodePudding user response:

Thanks to the great god, blog to learn writing

CodePudding user response:

Can, good thank you for your bosses