Local temporary table:-
A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement.
Global temporary table:-
1. Global temporary tables are visible to all sessions
2. Global temporary tables are dropped when the session that created it ends, and all other sessions have stopped referencing it