MySql 创建视图

1. 实列

CREATE  VIEW DBNAME.VIEWNAME
AS
SELECT
	`brs_base_card`.`card_id` AS `card_id`,
	`brs_base_card`.`user_id` AS `user_id`,
	`brs_base_card`.`user_name` AS `user_name`,
	`brs_base_card`.`card_amt` AS `card_amt`,
	`brs_base_card`.`cert_type` AS `cert_type`,
	`brs_base_card`.`cert_no` AS `cert_no`,
	`brs_base_card`.`valid_bg_time` AS `valid_bg_time`,
	`brs_base_card`.`valid_ed_time` AS `valid_ed_time`,
	`brs_base_card`.`op_user_id` AS `op_user_id`,
	`brs_base_card`.`op_user_name` AS `op_user_name`,
	`brs_base_card`.`cart_status` AS `cart_status`,
	`brs_base_card`.`update_time` AS `update_time`,
	`brs_base_card`.`creator` AS `creator`,
	`brs_base_card`.`creator_name` AS `creator_name`,
	`brs_base_card`.`create_time` AS `create_time` 
FROM
	`brs_base_card`

or like this:

CREATE ALGORITHM = UNDEFINED DEFINER = `root` @`%` SQL SECURITY DEFINER VIEW `brs_base_card_v` 
AS 
SELECT
`brs_base_card`.`card_id` AS `card_id`,
`brs_base_card`.`user_id` AS `user_id`,
`brs_base_card`.`user_name` AS `user_name`,
`brs_base_card`.`card_amt` AS `card_amt`,
`brs_base_card`.`cert_type` AS `cert_type`,
`brs_base_card`.`cert_no` AS `cert_no`,
`brs_base_card`.`valid_bg_time` AS `valid_bg_time`,
`brs_base_card`.`valid_ed_time` AS `valid_ed_time`,
`brs_base_card`.`op_user_id` AS `op_user_id`,
`brs_base_card`.`op_user_name` AS `op_user_name`,
`brs_base_card`.`cart_status` AS `cart_status`,
`brs_base_card`.`update_time` AS `update_time`,
`brs_base_card`.`creator` AS `creator`,
`brs_base_card`.`creator_name` AS `creator_name`,
`brs_base_card`.`create_time` AS `create_time` 
FROM
	`brs_base_card`

2. 查看视图
  SHOW CREATE VIEW VIEWNAME;