MYSQL 8 基本操作之05 (視圖)

1.創建視圖

root@127.0.0.1 : testdb【11:05:41】138 SQL->create or replace view v_mp_user as select * from mp_user;

root@127.0.0.1 : testdb【11:05:45】139 SQL->show create view v_mp_user \G;
*************************** 1. row ***************************
View: v_mp_user
Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_mp_user` AS select `mp_user`.`mp_user_seq` AS `mp_user_seq`,`mp_user`.`mp_user_name` AS `mp_user_name` from `mp_user`
character_set_client: utf8mb4
collation_connection: utf8mb4_0900_ai_ci