在MySQL中,执行LENGTH('单选题')这个函数,将得到哪个答案？

length()返回字符串str的长度，以字节为单位。 多字节字符计为多个字节。 3个3字节字符的字符串，LENGTH（）返回  9 。

select b.bank_id 序号,b.bank_name 题库名称,count(q.question_id) 总题量 ,q1.单选题量 单选题量,q2.多选题量 多选题量,q3.简答题量 简答题量,

from sp_questionbank b ,

sp_question q,

(select count(question_id) 单选题量,bank_id from sp_question where type_id = '1' group by bank_id) q1,

(select count(question_id) 多选题量,bank_id from sp_question where type_id = '2' group by bank_id) q2,

(select count(question_id) 简答题量,bank_id from sp_question where type_id = '3' group by bank_id) q3

where q.bank_id=b.bank_id and q1.bank_id=b.bank_id and q2.bank_id=b.bank_id and q3.bank_id=b.bank_id

group by q.bank_id

---