Getting started with MySQL Pro course


Contents:


Managing System Accounts
In order to create a new user in the MySQL system you need: log in as a user who has the ri...
Transactions
Транзакция is a set of system actions on data that either will be ...
Constructions IF, CASE-WHEN
In SQL, there are several statements for controlling the flow of commands, similar to the rest of th...
Stored procedures
Purpose процедур in MySQL is similar to the function of functions i...
Stored procedure parameters
The procedures may depend on the parameters. Parameters can be of three types - IN,
Triggers
Триггеры are special stored procedures. Their feature is that they ...
Stored functions
Functions differ from procedures in that they return a particular value. The created function can be...
Query analysis: EXPLAIN
Operator EXLPAIN is used for query analysis. Using this operator, you can see which re...