Prepare

Allocate

PREPARE <prepare> FROM <sql>;                           -- variable을 넣는 곳에는 ?을 넣음

Execute

EXECUTE <prepare> USING @<variable> , @<variable>, ...;

Deallocate

DEALLOCATE PREPARE <prepare>;