Which of the following are valid ways of returning information on whether the field value is present in the table animals?
A.
SHOW COLUMNS FROM animals
B.
SHOW COLUMNS FROM animals WHERE Field = ‘value’
C.
SHOW value FROM animals
D.
SELECT COLUMNS FROM animals. Value
E.
F. SELECT COLUMNS.value FROM animals WHERE Field = ‘value’
Explanation:
SHOW COLUMNS is same as describes, lists fields (ie column names). SELECT COLUMNS doesn’t exist.mysql> SHOW COLUMNS FROM Country WHERE FIELD = ‘name’;
+——-+———-+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+——-+———-+——+—–+———+——-+
| Name | char(52) | NO | | | |
+——-+———-+——+—–+———+——-+