PRACTICAL EXERCISE Explain the meaning of the following network parameters: IP address: Is a numerical label assigned to each device participating in a computer network that uses the Internet…
DAW
Linux
Networks
Ubuntu
Read more →
IF, LOOP, ITERATE, LEAVE, REPEAT/UNTIL and WHILE/DO. The IF statement: What is it? It is a statement; IF also exists as a function, and we should not confuse them. Syntax IF searchcondition THEN…
Databases
DAW
SQL
Read more →
What is a cursor? A cursor allows real-time access to the data of each row in a query. This mechanism is very useful when connecting MySQL with applications or performing complex queries. Declaration…
Databases
DAW
SQL
Read more →
CONCEPTES BÀSICS A trigger is an object associated with a table that is activated when an action occurs against that table. Usage example A trigger is set to fire when we insert a new grade outside…
Databases
DAW
SQL
Read more →
EMERGENCY AND SELF-PROTECTION PLAN Fire protection organization has two objectives: Minimize the number of fire emergencies Quickly control emergencies so that consequences are minimal. Temporal…
DAW
Read more →
MySQL stores user information in the tables of the mysql database (DB). The CREATE USER command creates new MySQL users. To use it, you must have the global CREATE USER privilege or the INSERT…
Databases
DAW
SQL
Terminal
Read more →
Definition: A stored procedure is a set of SQL commands that can be stored on the server. A stored procedure is a program that is physically saved in a database. Its implementation varies from one…
Databases
DAW
SQL
Read more →
VARIABLES Variables are used to store information locally. They can be used to store constants or query results. They are deleted when MySQL is restarted. The definition is divided into three parts…
Databases
DAW
Read more →
With views, we will work with external schemas. To create a view, you need to use the CREATE VIEW statement STRUCTURECREATE VIEW viewname [(columnlist)] AS (query) [WITH CHECK OPTION]; Views do not…
Databases
DAW
SQL
Read more →