구차니의 잡동사니 모음

$ mysql -u fooUser -p -h 44.55.66.77 

$ sudo ln -s /etc/apparmor.d/usr/sbin/mysqld /etc/apparmor.d/disable/ 

$ sudo mysql -uroot -p

[sudo] password for odroid:

Enter password:

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 34

Server version: 10.0.34-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

$ mysql --version

mysql  Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (armv7l) using readline 6.3 

$ mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 367

Server version: 5.5.59-0+deb8u1 (Raspbian)

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> show tables;

+-------------------+

| Tables_in_archlog |

+-------------------+

| account_bank      |

| account_periodic  |

| account_withdraw  |

| arch_article      |

| arch_blobs        |

| arch_refer        |

| arch_rel          |

| arch_reply        |

| arch_user         |

| org_detail        |

| org_rel           |

| organization      |

| people_detail     |

| people_rel        |

+-------------------+

14 rows in set (0.00 sec) 

mysql> desc organization;

+---------------+-----------+------+-----+---------+-------+

| Field         | Type      | Null | Key | Default | Extra |

+---------------+-----------+------+-----+---------+-------+

| idx           | int(11)   | NO   |     | 0       |       |

| name_kr       | char(50)  | YES  |     | NULL    |       |

| name_en       | char(30)  | YES  |     | NULL    |       |

| address       | char(200) | YES  |     | NULL    |       |

| call_1        | char(30)  | YES  |     | NULL    |       |

| fax           | char(30)  | YES  |     | NULL    |       |

| web           | char(50)  | YES  |     | NULL    |       |

| certification | char(20)  | YES  |     | NULL    |       |

| time_create   | datetime  | YES  |     | NULL    |       |

+---------------+-----------+------+-----+---------+-------+

9 rows in set (0.01 sec)

mysql> show create view organization\G; 

mysql> show create view organization; 

--auto-vertical-output

Cause result sets to be displayed vertically if they are too wide for the current window, and using normal tabular format otherwise. (This applies to statements terminated by ; or \G.) 

mysql> show full tables;

+-------------------+------------+

| Tables_in_archlog | Table_type |

+-------------------+------------+

| account_bank      | BASE TABLE |

| account_periodic  | BASE TABLE |

| account_withdraw  | BASE TABLE |

| arch_article      | BASE TABLE |

| arch_blobs        | BASE TABLE |

| arch_refer        | BASE TABLE |

| arch_rel          | BASE TABLE |

| arch_reply        | BASE TABLE |

| arch_user         | BASE TABLE |

| org_detail        | BASE TABLE |

| org_rel           | BASE TABLE |

| organization      | VIEW       |

| people_detail     | BASE TABLE |

| people_rel        | BASE TABLE |

+-------------------+------------+

14 rows in set (0.01 sec)