> > >

MySQL MCQs

Which is the correct query to find out the number of ENUM('M','F','NA') datatypes columns that exist in all databases?

SELECT count(*) FROM information_schema.columns WHERE data_type = 'enum' ;

select count(*) from information_schema.column where column_name="ENUM('M','F','NA')";

SELECT count(*) FROM information_schema.columns WHERE data_type = "ENUM('M','F','NA')" ;

SELECT count(*) FROM information_schema.columns WHERE column_type = "ENUM('M','F','NA')" ;

Answer

Correct Answer: SELECT count(*) FROM information_schema.columns WHERE data_type = 'enum' ;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it