| 123456789101112131415 |
- TYPE=VIEW
- query=select `mooctest_user`.`user`.`name` AS `name`,`mooctest_user`.`user`.`email` AS `email`,`mooctest_user`.`user`.`mobile` AS `mobile`,`mooctest_user`.`user_address`.`address` AS `address` from (`mooctest_user`.`user` join `mooctest_user`.`user_address`) where (`mooctest_user`.`user`.`id` = `mooctest_user`.`user_address`.`user_id`)
- md5=1ae1eadb1ecb48b2304f9c528107b651
- updatable=1
- algorithm=0
- definer_user=root
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2020-12-29 08:06:08
- create-version=1
- source=select `user`.`name` AS `name`,`user`.`email` AS `email`,`user`.`mobile` AS `mobile`,`user_address`.`address` AS `address` from (`user` join `user_address`) where (`user`.`id` = `user_address`.`user_id`)
- client_cs_name=utf8mb4
- connection_cl_name=utf8mb4_general_ci
- view_body_utf8=select `mooctest_user`.`user`.`name` AS `name`,`mooctest_user`.`user`.`email` AS `email`,`mooctest_user`.`user`.`mobile` AS `mobile`,`mooctest_user`.`user_address`.`address` AS `address` from (`mooctest_user`.`user` join `mooctest_user`.`user_address`) where (`mooctest_user`.`user`.`id` = `mooctest_user`.`user_address`.`user_id`)
|
