怎么获取视图的字段类型和长度?
SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name = 'your_view_name';
看是否是想要的