视图的优点:
- 有利于隐藏一些表的字段,安全
- 简单,对于复杂的查询,只需要在数据库中select *from 视图名
视图创建:
select `b`.`id` AS `id`,`b`.`content` AS `con`,`b`.`category` AS `category`,`b`.`title` AS `title`,`m`.`content` AS `content`,`m`.`nick_name` AS `nick_name` from (`blog` `b` join `message` `m`) where (`m`.`blog_id` = `b`.`id`)