http://dev.mysql.com/doc/refman/5.1/zh/views.html
CREATE OR REPLACE VIEW pro_info AS (SELECT p.id, t.name, p.pro_name FROM tb_pros p LEFT JOIN tb_types t ON (p.type_id = t.id));
SELECT p.id, t.name, p.pro_name FROM tb_pros p LEFT JOIN tb_types t ON (p.type_id = t.id);
SELECT * FROM pro_info;
ALTER VIEW pro_info AS (SELECT * FROM tb_pros);