Pg7Wdt5A

1- 문자셋
2SHOW VARIABLES LIKE 'c%';
3Database:
4(CREATE | ALTER) DATABASE ... DEFAULT CHARACTER SET utf8
5
6Table:
7(CREATE | ALTER) TABLE ... DEFAULT CHARACTER SET utf8
8
9
10USE dataset;
11
12DROP TABLE IF EXISTS model_id_map;
13CREATE TABLE model_id_map (
14    id int unsigned NOT NULL AUTO_INCREMENT,
15    model_id int unsigned NOT NULL,
16    local_id int unsigned NOT NULL,
17    global_id int unsigned NOT NULL,
18    effective bool NOT NULL DEFAULT TRUE,
19 
20    created_at timestamp NOT NULL DEFAULT current_timestamp,
21    updated_at timestamp NOT NULL DEFAULT current_timestamp ON UPDATE current_timestamp,
22     
23    PRIMARY KEY (id),
24    FOREIGN KEY (global_id) REFERENCES global_id (id),
25    FOREIGN KEY (model_id) REFERENCES model (id),
26    UNIQUE(model_id, local_id)
27);
28
29- 삭제
30DELETE FROM dbtool_id WHERE [ì¡°ê±´];
31
32
33- 시간
34SELECT UNIX_TIMESTAMP();
35SELECT NOW();
36SELECT date_format( UNIX_TIMESTAMP() , "%Y-%m-%d %H:%i:%S");
37
38SHOW VARIABLES WHERE Variable_name LIKE '%time_zone%';
39SET time_zone = 'Asia/Seoul';
40
41SELECT @@global.time_zone, @@session.time_zone;
42
43- 삽입
44INSERT INTO global_id_trans (global_id, code, name) VALUES (50008, 'ko', '캐주얼재킷');
45
46- 수정
47UPDATE [테이블명] SET [필드명] = [필드값] WHERE [검색조건];