Programmatic SQL Flashcards

Question 1

Q

What is a procedure in MySQL?

Answer

A

A stored routine that has to be called in the SQL code

Question 2

Q

What is a function in MySQL?

Answer

A

A stored routine that returns a value, it is not called and instead appears as or as part of an expression

Question 3

Q

What is a trigger in MySQL?

Answer

A

A stored routine that takes place when a particular event occurs

Question 4

Q

What is the syntax of a procedure?

Answer

A

CREATE PROCEDURE <proc-name>  
	( [IN|OUT|INOUT] <param-1> <type-1>,  
	... ,  
[IN|OUT|INOUT] <param-n> <type-n>  
)  
BEGIN  
[ DECLARE <var-name-1> <type-1>; ...] /*local variables*/ 
<body>  /*SQL statements*/
END <delimiter-sym>

Question 5

Q

What is the syntax of a function?

Answer

A

CREATE FUNCTION <func-name>(  
	<param-1><type-1>, ... ,<param-n><type-n>)  
	RETURNS <return-type>  
BEGIN  
[ DECLARE <var-name-1> <type-1>; ...]  
<body>  
RETURN <expression>;  
END  
<delimiter-sym>

Question 6

Q

What is the syntax of a trigger?

Answer

A

CREATE TRIGGER <trigger-name>  
(BEFORE | AFTER) <event-type>  
ON <which-table>  
FOR EACH ROW  
BEGIN  
<block-of-actions>  
END

Programmatic SQL Flashcards

(6 cards)