구차니의 잡동사니 모음

• Pulseaudio updated to 10.0 (9.0)
• Binutils updated to 2.28 (2.26)
• GCC updated to 6.3 (5.4)
• glibc updated to 2.25 (2.23)
• LLVM updated to 4.0 (3.8)
• Linux kernel updated to 4.9 (4.4)
• Mesa updated to 17.0 (11.2)
• ffmpeg updated to 3.2 (2.8)
• libva updated to 1.8 (1.7)
• connman updated to 1.33 (1.31)
• libressl updated to 2.4 (2.2)
• systemd updated to 233 (229)
• xorg-server updated to 1.19 (1.18)
• samba updated to 4.6 (3.6)
• MySQL replaced with MariaDB-10.1
• HFS and HFS+ Filesystem support removed.
• iSCSI support removed.
• NFS, NBD, iSCSI Network boot support removed.
• LIRC support removed, LIRC was always installed as a enhancenment to the Kernel RC drivers, and was only used for very old IR Hardware like classic XBox remote and others - which support is now dropped.
• Apple TV 1 IR remote driver driver removed.
• X11 AMDGPU, ATI (Radeon) and Intel GPU driver driver replaced by X11 Modesettings GPU driver.

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) 

git fetch(서버에서 받아오기)

git merge(병합)

>> git pull

git checkout (브랜치 선택)

git commit 로컬 저장소 저장

git push 원격 저장소 저장

git clone

git init (로컬 저장소 생성)

git remote add repo (로컬 저장소와 원격저장소 연결)

git pull (원격 저장소의 정보를 내려받음)

>> git clone repo (로컬 저장소와 원격저장소 동일)