Que: What column names are displayed when this SQL command is executed?

SHOW COLUMNS FROM tbl_name LIKE '%name';
a. suffixed with ‘name’
b. prefixed with ‘name’
c. suffixed with ‘%name’
d. prefixed with ‘%name’
Answer: suffixed with ‘name’

Leave a Comment