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`;

上一篇:ubuntu14.04安装、NVIDIA显卡驱动安装及CUDA8.0、Cudnn5.1的环境搭建


下一篇:textarea 多行文本保存数据到DB,取出后恢复换行