Which of the following is the correct way to create a prepared statement using this statement in the mysql client?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *