{"id":275,"date":"2014-08-05T21:56:43","date_gmt":"2014-08-06T06:56:43","guid":{"rendered":"http:\/\/blog.box.kr\/?p=275"},"modified":"2014-08-05T21:56:43","modified_gmt":"2014-08-06T06:56:43","slug":"db%eb%b3%84-%ed%95%a8%ec%88%98-%eb%b9%84%ea%b5%90","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=275","title":{"rendered":"DB\ubcc4 \ud568\uc218 \ube44\uad50"},"content":{"rendered":"

isnull => DB2\u00a0COALESCE<\/span><\/p>\n

strcat = > || \ub85c \ubb36\uae30<\/p>\n

 <\/p>\n

 <\/p>\n

MySQL<\/strong>:
\n— Convert the current date to YYYYMM format
\n<\/span>\u00a0\u00a0SELECT<\/span> DATE_FORMAT(<\/span>NOW(<\/span>)<\/span>,<\/span> ‘%Y%m’<\/span>)<\/span>;<\/p>\n

DB2<\/strong>:
\n— Convert the current date to YYYYMM format
\n<\/span>\u00a0\u00a0SELECT<\/span> VARCHAR_FORMAT(<\/span>CURRENT_DATE,<\/span> ‘YYYYMM’<\/span>)<\/span> FROM<\/span> sysibm.<\/span>sysdummy1;<\/p>\n","protected":false},"excerpt":{"rendered":"

isnull => DB2\u00a0COALESCE strcat = > || \ub85c \ubb36\uae30     MySQL: — Convert the current date to YYYYMM format \u00a0\u00a0SELECT DATE_FORMAT(NOW(), ‘%Y%m’); DB2: — Convert the current date to YYYYMM format \u00a0\u00a0SELECT VARCHAR_FORMAT(CURRENT_DATE, ‘YYYYMM’) FROM sysibm.sysdummy1;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[6],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-4r","jetpack-related-posts":[{"id":741,"url":"https:\/\/blog.box.kr\/?p=741","url_meta":{"origin":275,"position":0},"title":"[DB2] how to use Sequence table","date":"2015-05-07","format":false,"excerpt":"1. describe sequence table describe table syscat.sequences; 2.\u00a0 select sequence information SELECT * FROM syscat.sequences; 3. create sequence CREATE SEQUENCE seq_tab START WITH 1 INCREMENT BY 1 NOMAXVALUE NOCYCLE CACHE 24; -> start 1, increment\u00a01 by 1 \u00a0to\u00a0\u00a0no limit CREATE SEQUENCE seq_tab START WITH 1 INCREMENT BY 1 maxvalue 10000\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":427,"url":"https:\/\/blog.box.kr\/?p=427","url_meta":{"origin":275,"position":1},"title":"[DB] DB\ubcc4 \uac00\uc0c1 \ud14c\uc774\ube14","date":"2014-12-04","format":false,"excerpt":"Oracle ] select aaaa from dual DB2] select aaaa from\u00a0sysibm.sysdummy1 \u00a0","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":619,"url":"https:\/\/blog.box.kr\/?p=619","url_meta":{"origin":275,"position":2},"title":"[\ud38c][IBM][CLI Driver] SQL0418N SQLSTATE=42610","date":"2015-03-13","format":false,"excerpt":"\uac1c\uad04 :\u00a0[IBM][CLI Driver] SQL0418N\u00a0SQLSTATE=42610 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\uba85\ub839\ubb38\uc5d0 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\uac00 \uc0ac\uc6a9\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc6d0\uc778: \ub2e4\uc74c \uacbd\uc6b0\uc5d0\ub294 \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc9c0 \uc54a\uc740 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. SELECT \ubaa9\ub85d\uc5d0\uc11c \ub0a0\uc9dc \uc2dc\uac04 \uc0b0\uc220 \uc5f0\uc0b0\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c \uacbd\uc6b0\uc5d0 \ub530\ub77c \uc2a4\uce7c\ub77c \ud568\uc218\uc758 \uc720\uc77c\ud55c \uc778\uc218\ub85c ORDER BY\uc808\uc5d0\uc11c \uc815\ub82c \ud0a4\ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0 \ub9e4\uac1c\ubcc0\uc218 \ud45c\uc2dc\ubb38\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc900\ube44\ub41c \uba85\ub839\ubb38\uc774\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":345,"url":"https:\/\/blog.box.kr\/?p=345","url_meta":{"origin":275,"position":3},"title":"Alter Table [ \uceec\ub7fc \uc0ac\uc774\uc988, \ub370\uc774\ud130 \ud06c\uae30 \uc870\uc815 ]","date":"2014-08-17","format":false,"excerpt":"[DB2] \ucef4\ub7fc\uc758 \ub370\uc774\ud130 \ud0c0\uc785 \ub610\ub294 \uc0ac\uc774\uc988 \uc870\uc815 ALTERTABLE temp \u00a0 \u00a0\u00a0ALTERCOLUMN col1 SET DATA TYPE VARCHAR(60); [ORACLE] alter table\u00a0\u00a0 table_namemodify\u00a0\u00a0 column_name\u00a0 datatype; \uc774\ub7f0\uc2dd\uc73c\ub85c\ub3c4 \ub41c\ub2e4.. alter table\u00a0\u00a0 table_namemodify\u00a0\u00a0 (\u00a0\u00a0 column1_name\u00a0 column1_datatype,\u00a0\u00a0 column2_name\u00a0 column2_datatype,\u00a0\u00a0 column3_name\u00a0 column3_datatype,\u00a0\u00a0 column4_name\u00a0 column4_datatype\u00a0\u00a0 ); [MYSQL] alter table people modify name VARCHAR(35) ;","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":803,"url":"https:\/\/blog.box.kr\/?p=803","url_meta":{"origin":275,"position":4},"title":"[scrap]mysqldump \uc635\uc158 \ubc0f \uc0ac\uc6a9\ubc95","date":"2015-05-18","format":false,"excerpt":"http:\/\/egloos.zum.com\/simonshin\/v\/2247509 \u00a0 1. mysqldump \uc635\uc158 \uc911 binary log \uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4 \uac19\uc774 dump \ud558\uae30 \/usr\/local\/mysql\/bin\/mysqldump -uroot -p --master-data=2\u00a0 > \/data\/\u2026\/backup.sql \uc774 \uba85\ub839\uc5b4 \uc911\uc5d0\uc11c \"--master-data=2\" \uc635\uc158\uc744 \uc8fc\uac8c \ub418\uba74 \ub364\ud504 \uc2dc\uc810\uc758 binary log\uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4\uac00 \uac19\uc774 Dump \ub418\uac8c \ub41c\ub2e4. Dump\ub41c \ud30c\uc77c\uc744 \uc5d0\ub514\ud130\ub85c \uc5f4\uc5b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ub098\uc628\ub2e4. 2. Table Lock \uac78\uae30 FLUSH\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1161,"url":"https:\/\/blog.box.kr\/?p=1161","url_meta":{"origin":275,"position":5},"title":"POCO \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c MYSQL Query\uc2dc\uc5d0 “unknown field type” \uc624\ub958","date":"2016-08-31","format":false,"excerpt":"\uc6d0\uc778\uc740.. \u00a0POCO\uc5d0\uc11c\u00a0MYSQL\uc758 TIMESTAMP \ud0c0\uc785\uc744 \uc9c0\uc6d0 \ud558\uc9c0 \uc54a\uc544\uc11c \uc0dd\uae34 \ubb38\uc81c. \uc774\ub97c \ud574\uacb0 \ud558\uae30 \uc704\ud574\uc11c POCO\ub77c\uc774\ube0c\ub7ec\ub9ac \uc18c\uc2a4\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 \ud55c \ud6c4\uc5d0 \uc7ac \ucef4\ud30c\uc77c \ud574\uc900\ub2e4. POCO \uc18c\uc2a4 \ud3f4\ub354\uc5d0\uc11c Data\/MySQL\/src\/ResultMetadata.cpp \uc758 \ub0b4\uc6a9\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 std::size_t fieldSize(const MYSQL_FIELD& field) \/\/\/ Convert field MySQL-type and field MySQL-length to actual field length { ... case\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/275"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=275"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/275\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}