[root@itop ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 8.0.13-3 Percona Server (GPL), Release 3, Revision a920dd6
Copyright (c) 2009-2018 Percona LLC and/or its affiliates
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> select c.id,c.name as contact_name,o.name as org_name,c.email,c.phone,c.notify from itop_data.contact c,itop_data.organization o where c.org_id = o.id order by c.id;
+----+------------------------------+-----------------------+----------------------+-----------------+--------+
| id | contact_name | org_name | email | phone | notify |
+----+------------------------------+-----------------------+----------------------+-----------------+--------+
| 1 | My last name | My Company/Department | my.email@foo.org | +00 000 000 000 | yes |
| 2 | Picasso | Demo | pablo@demo.com | | yes |
| 3 | Dali | Demo | dali@demo.com | | yes |
| 4 | Rousseau | IT Department | rousseau@it.com | | yes |
| 5 | Delacroix | Demo | delacroix@demo.com | | yes |
| 6 | Monet | Demo | monet@demo.com | | yes |
| 7 | Hugo | IT Department | hugo@it.com | | yes |
| 8 | Kahlo | Demo | frida.kahlo@demo.com | | yes |
| 9 | Verne | IT Department | vernes@it.com | | yes |
| 10 | Flaubert | IT Department | flaubert@it.com | | yes |
| 11 | Cocteau | IT Department | cocteau@it.com | | yes |
| 12 | Gavalda | IT Department | gavalda@it.com | | yes |
| 13 | Duras | IT Department | duras@it.com | | yes |
| 14 | Sartre | IT Department | sartre@it.com | | yes |
| 15 | Christie | Demo | christie@demo.com | | yes |
| 16 | Vian | IT Department | vian@it.com | | yes |
| 17 | Parker | IT Department | parker@it.com | | yes |
| 18 | De Luca | Demo | deluca@demo.com | | yes |
| 19 | Kubrick | IT Department | kubrick@it.com | | yes |
| 20 | King | IT Department | king@it.com | | yes |
| 21 | de Beauvoir | IT Department | simone@it.com | | yes |
| 22 | Hardware support | IT Department | hw@test.com | | yes |
| 23 | Helpdesk | IT Department | | | yes |
| 24 | Network support | IT Department | nw@test.com | | yes |
| 25 | System & application support | IT Department | | | yes |
| 26 | 王宝强 | IT Department | wangbaoqiang@me.com | | yes |
+----+------------------------------+-----------------------+----------------------+-----------------+--------+
26 rows in set (0.01 sec)
mysql>
Adamhuan
