Consider the following query:
SELECT Code FROM Country WHERE Name = ‘United States’
Which of the following is the correct way to create a prepared statement using this statement in the mysql client?
A.
mysql> PREPARE CountryCode AS ‘SELECT Code FROM Country WHERE Name = ? ‘;
B.
mysql> PREPARE CountryCode FROM ‘SELECT Code FROM Country WHERE Name = ? ‘;
C.
mysql> PREPARE STATEMENT CountryCode AS ‘SELECT Code FROM Country WHERE Name = ? ‘;
Explanation:
PREPARE statement_name FROM ‘SELECT STATEMENT….’; options with AS don’t work.