구차니의 잡동사니 모음

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 (로컬 저장소와 원격저장소 동일) 

SET GLOBAL innodb_file_per_table=1;

SET GLOBAL innodb_file_format=Barracuda; 

• Antelope is the original InnoDB file format, which previously did not have a name. It supports COMPACT and REDUNDANT row formats for InnoDB tables and is the default file format in MySQL 5.6 to ensure maximum compatibility with earlier MySQL versions that do not support the Barracuda file format.

• Barracuda is the newest file format. It supports all InnoDB row formats including the newer COMPRESSED and DYNAMIC row formats. The features associated with COMPRESSED and DYNAMIC row formats include compressed tables, efficient storage of off-page columns, and index key prefixes up to 3072 bytes (innodb_large_prefix). See Section 14.11, “InnoDB Row Storage and Row Formats”.