본문 바로가기

DB/Mysql

[mysql] binlog 설정 방법 하루동안 저장하고 그 뒤 자동지우기 설정하는 방법. mysql> SHOW VARIABLES LIKE '%expire%' -> ; +--------------------------------+---------+ | Variable_name | Value | +--------------------------------+---------+ | binlog_expire_logs_auto_purge | ON | | binlog_expire_logs_seconds | 2592000 | | disconnect_on_expired_password | ON | | expire_logs_days | 0 | +--------------------------------+---------+ 4 rows in set (0.00 .. 더보기
[mysql] systemctl start mysqld 오류 (mysqld.service: main process exited, code=exited,...) 8월 12 14:01:52.cafe24.com systemd[1]: Starting MySQL Server... 8월 12 14:01:55.cafe24.com systemd[1]: mysqld.service: main process exited, code=exited, sta...URE 8월 12 14:01:55.cafe24.com systemd[1]: Failed to start MySQL Server. 8월 12 14:01:55.cafe24.com systemd[1]: Unit mysqld.service entered failed state. 8월 12 14:01:55.cafe24.com systemd[1]: mysqld.service failed. 1. /var/lib/mysql 폴더의 로그 파일(.. 더보기
[mysql] KMA(기상청) API 테이블/INDEX CREATE 1.API 목록을 관리하는 테이블 CREATE CREATE TABLE API_I ( API_NM VARCHAR(30) NOT NULL, /*API명*/ API_DVCD VARCHAR(2) NOT NULL, /*API구분코드 01:getUltraSrtNcst*/ API_INST_CD VARCHAR(3) NOT NULL, /*API기관코드 e.g)KMA(기상청)*/ API_URL VARCHAR(300) NOT NULL, /*API_URL*/ API_KEY VARCHAR(300) NOT NULL, /*API_KEY*/ RMK VARCHAR(200) NOT NULL, /*비고 : 초단기예보*/ CONSTRAINT API_I_PK PRIMARY KEY(API_NM,API_DVCD,API_INST_CD) ); 2... 더보기
[mysql] 컬럼추가하기/컬럼삭제하기 --컬럼 추가 ALTER TABLE `테이블명` ADD `컬럼명` VARCHAR(200) NOT NULL AFTER `다른컬럼(이거보다 뒷쪽에 컬럼 추가)`; ALTER TABLE `API_I` ADD `API_URL` VARCHAR(300) NOT NULL AFTER `API_INST_CD`; ALTER TABLE `API_I` ADD `API_KEY` VARCHAR(300) NOT NULL AFTER `API_INST_CD`; --컬럼 삭제 ALTER TABLE `API_I` DROP `컬럼명`; 더보기
[mysql] 기상청(KMA) 초단기실황조회 API 테이블 CREATE, INSERT, SELECT, TRUNCATE, DROP, PRIMARY KEY SETUP 테이블 CREATE 문 CREATE TABLE KMA_ULTRA_SRT_NCST( BASE_DT VARCHAR(8) NOT NULL, BASE_TM VARCHAR(6) NOT NULL, NX INT(3) NOT NULL, NY INT(3) NOT NULL, CATEGORY VARCHAR(3) NOT NULL, DATA_VALUE DOUBLE(17,3) NOT NULL, CONSTRAINT KMA_ULTRA_SRT_NCST_PK PRIMARY KEY(BASE_DT,BASE_TM,NX,NY,CATEGORY) ); SELECT * FROM KMA_ULTRA_SRT_NCST; INSERT INTO KMA_ULTRA_SRT_NCST (BASE_DT, BASE_TM, NX,NY,CATEGORY, DATA_VALUE.. 더보기
[mysql] Mysql8.0 접속을 위한 Workbench 설치 https://dev.mysql.com/downloads/workbench/ MySQL :: Download MySQL Workbench Select Operating System: Select Operating System… Microsoft Windows Ubuntu Linux Red Hat Enterprise Linux / Oracle Linux Fedora macOS Source Code Select OS Version: All Windows (x86, 64-bit) Recommended Download: Other Downloads: Windows (x86, 64-bit), M dev.mysql.com 1. 위에서 적절한 OS 선택하고 다운로드 선택. 2. 응용프로그램으로 다운로드 받은 dmg .. 더보기
[mysql] mysql 8.0 외부접속 허용 (계정생성) 1. 신규 계정 생성 use mysql; create user '계정명'@'%' identified by '비밀번호'; select user, host from user; mysql> select user, host from user; +------------------+-----------+ | user | host | +------------------+-----------+ | 계정멍 | % | | mysql.infoschema | localhost | | mysql.session | localhost | | mysql.sys | localhost | | root | localhost | +------------------+-----------+ 5 rows in set (0.00 sec) 2. 권.. 더보기
[mysql] centos mysql 8.0 설치 1.저장소설치 yum install https://dev.mysql.com/get/mysql80-community-release-el7-6.noarch.rpm Loaded plugins: fastestmirror mysql80-community-release-el7-6.noarch.rpm | 11 kB 00:00:00 Examining /var/tmp/yum-root-wnHzco/mysql80-community-release-el7-6.noarch.rpm: mysql80-community-release-el7-6.noarch Marking /var/tmp/yum-root-wnHzco/mysql80-community-release-el7-6.noarch.rpm to be installed Resolving.. 더보기

티스토리툴바