Which option enables multiple-statement execution?
(a) CLIENT_MULTI_STATEMENTS
(b) CLIENT_STATEMENTS_MULTI
(c) MULTI_STATEMENTS_CLIENT
(d) MULTI_CLIENTS_STATEMENTS
(a) CLIENT_MULTI_STATEMENTS
(b) CLIENT_STATEMENTS_MULTI
(c) MULTI_STATEMENTS_CLIENT
(d) MULTI_CLIENTS_STATEMENTS
The correct choice is (a) CLIENT_MULTI_STATEMENTS
Explanation: There are two ways to enable the multiple-statement execution. The first is to add the ‘CLIENT_MULTI_STATEMENTS’ option in the flags argument to ‘mysql_real_connect()’ at connect time.