mysql创建视图

CREATE ALGORI`sync_user`CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `sync_db`.`sync_user` AS select
     `ipt_authd_remote`.`user`.`user_login_name` AS `user_login_name`,
     `ipt_authd_remote`.`user`.`user_real_name` AS `user_real_name`,
     `ipt_authd_remote`.`user`.`last_login_time` AS `last_login_time`,
     `ipt_authd_remote`.`user`.`user_balance` AS `user_balance` from `ipt_authd_remote`.`user`;

转载于:https://www.cnblogs.com/xlz307/p/4153269.html