로이랜드

원래 쿼리 ) SELECT DATE_FORMAT(CONCAT(JOB_DATE,JOB_TIME),'%Y-%m-%d %H:%i:%s') AS collect_date , CAPACITY_ID , B.pattern_code_name AS CAPACITY_NAME , CAPACITY_SUB_ID, , B2.pattern_code_name AS CAPACITY_SUB_NAME FROM tb_data A, tb_common_code B, tb_common_code B2 WHERE 1=1 AND job_date >= "20120827" AND job_date = "20120827000000" AND CONCAT(job_date,job_time) < "20120828000000" AND job_time '' AND A...

mysql 을 서버에서 자주 쓰는 사람들이라면 익숙할 명령어 : -e mysql -u$USER -p$PW $DB -e "select * from table_name" 을 하면 $ mysql --local-infile=1 -e "select * from TABLE_NAME limit 10;"+----------------------------------+---------------------+---------------------+-------------+------------+------------+-------------+--------------------+----- collect_date | equip_date | key_id | data_id | point_id | point_value | poi..

Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [ApplicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'URL [jar:file:*************/SyncSQLMap.xml]'; nested exception is org.apac..

이 키워드로 들어오는 분들이 많아서 추가글 링크도 남긴다. foreach 처음 사용해봣을때의 글이니 어색하다.. 추가작업내용 : [MyBatis] 동적 쿼리문 만들기 (List insert, foreach)https://vivi-world.tistory.com/50 [MyBatis] 객체 (VO, DTO) 안의 리스트를 사용해서 인서트 작업하기https://vivi-world.tistory.com/40 * 결론 INSERT INTO collect_data_result ( collect_date, collect_time, table_name, target_table, building_id , flag, type, execute_time, count, remark ) VALUES ("${item.collec..

# !/bin/bashDIR='pwd' HOST=localhostUSER=eunbiPW=eunbi123!DB=eunbi echo "[ LOADER ] Start : " $(date +%F) $(date +%T) >> ./log/result_import.txt TNAME=eunbi_dataFDIR=$DIR/data/ TOTAL_START_TIME=$(date +%s) echo -e "DIR Name : $FDIR" for FNAME in $(ls $FDIR) do START_TIME=$(date +%s) echo $FNAME echo $(mysql --local-infile=1 -u$USER -p$PW $DB -e "LOAD DATA LOCAL INFILE '$FDIR/$FNAME' INTO TABLE $..

ex)데이터 : varchar (8) 20170316 변환하고 싶은 형태 2017-03-16 DATE_FORMAT(STR_TO_DATE(date, '%Y%m%d'),'%Y-%m-%d ') *DATE_FORMAT ( Date, format ) Date타입의 값을 format에 지정한대로 출력해준다. * STR_TO_DATE( string, format )The STR_TO_DATE() converts the str string into a date value based on the fmt format string. The STR_TO_DATE() function may return a DATE , TIME, or DATETIME value based on the input and format strings..

CSV 파일을 임포트 할 때 Enclosing을 "" 으로 해서 그런지, 널이면 그냥 ""

MariaDB [(none)]> status--------------mysql Ver 15.1 Distrib 10.1.28-MariaDB, for Linux (x86_64) using readline 5.1Connection id: 62Current database:Current user: otdev@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server: MariaDBServer version: 10.1.28-MariaDB MariaDB ServerProtocol version: 10Connection: Localhost via UNIX socketServer characterset: latin1Db c..