{"id":669,"date":"2016-08-23T16:49:45","date_gmt":"2016-08-24T01:49:45","guid":{"rendered":"\/blog\/?p=669"},"modified":"2023-09-21T09:37:58","modified_gmt":"2023-09-21T00:37:58","slug":"safenet-datasecure-%eb%b3%b5%ed%98%b8%ed%99%94-sql-%ec%83%98%ed%94%8c","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=669","title":{"rendered":"SafeNet DataSecure \ubcf5\ud638\ud654 SQL \uc0d8\ud50c"},"content":{"rendered":"\n

\/\/ \ubcf5\ud638\ud654<\/span><\/font><\/font><\/p>\r\n

\r\n<\/span>SELECT<\/span><\/font> <\/span>\"ing_row_id\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"version_new\"<\/span><\/font>\r\n<\/span>
FROM<\/span><\/font>   <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font>\r\n<\/span>
WHERE<\/span><\/font>  <\/span>(<\/span><\/font> <\/span>version_new<\/span><\/font> <\/span>IS<\/span><\/font> <\/span>NOT<\/span><\/font> <\/span>NULL<\/span><\/font> <\/span>)<\/span><\/font>\r\n<\/span>
ORDER<\/span><\/font>  <\/span>BY<\/span><\/font> <\/span>ing_row_id<\/span><\/font>\r\n<\/span>
\r\n<\/span>
UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font>\r\n<\/span>
SET<\/span><\/font>    <\/span>\"version\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>ingrian<\/span><\/font>.<\/span><\/font>Ingrawtostring<\/span><\/strong><\/font>(<\/span><\/font>?<\/span><\/font>)<\/span><\/font>\r\n<\/span>
WHERE<\/span><\/font>  <\/span>ing_row_id<\/span><\/font> <\/span>=<\/span><\/font> <\/span>?<\/span><\/font><\/font><\/p>\r\n


<\/font><\/font><\/p>\r\n


<\/font><\/font><\/p>\r\n


<\/font><\/font><\/p>\r\n

\/\/ \ud14c\uc774\ube14 \uc815\ub9ac<\/span><\/font><\/font><\/p>\r\n


<\/font><\/font><\/p>\r\n

<\/font><\/font>S<\/span>ELECT<\/span><\/span><\/font> <\/span>ing_row_id<\/span><\/font>\r\n<\/span>
FROM<\/span><\/font>   <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font>\r\n<\/span>
ORDER<\/span><\/font>  <\/span>BY<\/span><\/font> <\/span>ing_row_id<\/span><\/font>\r\n<\/span>
\r\n<\/span>
UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font>\r\n<\/span>
SET<\/span><\/font>    <\/span>\"customer\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>' '<\/span><\/font>\r\n<\/span>
WHERE<\/span><\/font>  <\/span>ing_row_id<\/span><\/font> <\/span>=<\/span><\/font> <\/span>?<\/span><\/font>\r\n<\/span>
\r\n<\/span>
ALTER<\/span><\/font> <\/span>TABLE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font>\r\n<\/span>
  <\/span>DROP<\/span><\/font> <\/span>COLUMN<\/span><\/font> <\/span>\"version_new\"<\/span><\/font> <\/span>\r\n<\/font>\r\n<\/p>\r\n<\/font>\n","protected":false},"excerpt":{"rendered":"

\/\/ \ubcf5\ud638\ud654 SELECT “ing_row_id”,        “version_new” FROM   “ESVALI_TECH”.”tb_tech_history_hasu0707_new” WHERE  ( version_new IS NOT NULL ) ORDER  BY ing_row_id UPDATE “ESVALI_TECH”.”tb_tech_history_hasu0707_new” SET    “version” = ingrian.Ingrawtostring(?) WHERE  ing_row_id = ? \/\/ \ud14c\uc774\ube14 \uc815\ub9ac SELECT ing_row_id FROM   “ESVALI_TECH”.”tb_tech_history_hasu0707_new” ORDER  BY ing_row_id UPDATE “ESVALI_TECH”.”tb_tech_history_hasu0707_new” SET    “customer” = ‘ ‘ WHERE  ing_row_id = ? ALTER TABLE “ESVALI_TECH”.”tb_tech_history_hasu0707_new”   DROP COLUMN “version_new” <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-669","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=669"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/669\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}