[ Mysql ] 데이터 베이스 charset 확인

로긴
#>mysql -u root -p
password:

mysql> show create database eccube_db \G
*************************** 1. row ***************************
       Database: eccube_db
Create Database: CREATE DATABASE `eccube_db` /*!40100 DEFAULT CHARACTER SET utf8 */
1 row in set (0.00 sec)

utf8로 설정 되있는 것이다.

[ mysql ] database 데이터 베이스 charset 확인

로긴
#>mysql -u root -p
password:

#>\s

ysql  Ver 14.14 Distrib 5.1.59, for Win32 (ia32)

onnection id:          5
urrent database:
urrent user:           root@localhost
SL:                    Not in use
sing delimiter:        ;
erver version:         5.1.59-community MySQL Community Server (GPL)
rotocol version:       10
onnection:             localhost via TCP/IP
erver characterset:    utf8
b     characterset:    utf8
lient characterset:    utf8
onn.  characterset:    utf8
CP port:               3306
ptime:                 38 min 31 sec

hreads: 1  Questions: 14  Slow queries: 0  Opens: 15  Flush tables:
es: 0  Queries per second avg: 0.6

[ Mysql ] insert 기본 구문

insert 기본 구문 샘플

mysql> INSERT INTO book_list
    -> (book_id, title, author, price, comments)
    -> VALUES
    -> (1, 'book_A', 'auth_A', 1500, 'good, bad, excellence');