{
  "block": 106150687,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "7116.595964 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-18T06:18:45",
  "trx_id": "7c186ce6eea18d366fd60bf557620b341a387811",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 106005225,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "4404.385559 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-13T04:29:36",
  "trx_id": "034965d4b83233d292658cb17a606534a5b9e1e6",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 105518169,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "7129.111720 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-04-26T05:30:24",
  "trx_id": "9b44d438637a5fbca9a875775f79f29dd9b71ffe",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 102871361,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "4445.932378 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-01-24T00:07:18",
  "trx_id": "d519658612b24e0851606d91746c311d22930867",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 91317571,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "4610.151575 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2024-12-17T19:17:06",
  "trx_id": "c1492e652ececaf900711cc11c7edba64ddf2242",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 79871720,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "4779.285107 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-11-14T10:58:21",
  "trx_id": "27287c1a9eac89df2e01f886b108180f1a8251d9",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 78362912,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "7716.193893 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-09-22T10:25:51",
  "trx_id": "ef1c8a85ca6a1582827acfab5a2e4a8a0a0410a9",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 69120640,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "7938.245331 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-11-03T17:52:51",
  "trx_id": "e7ea6322d1d1ed24b1bd4ca0c19dc6b8d9b7cf60",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 60823883,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "8158.352932 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-17T23:04:30",
  "trx_id": "16af3d78bca5b54b8e61a4de4bda3bd8969fed0c",
  "trx_in_block": 34,
  "virtual_op": 0
}

{
  "block": 54614206,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "8342.547220 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-06-14T06:15:24",
  "trx_id": "b05ed8aea1037012b551002d419b01e921d396b3",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 49361470,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "8529.969194 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-11T16:27:36",
  "trx_id": "164e996d6a8bbfa9de955db7bac550bdb97e01d0",
  "trx_in_block": 12,
  "virtual_op": 0
}

{
  "block": 49212990,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "1912.543513 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-06T10:03:12",
  "trx_id": "bbc41262ca2a3e8770857929aad0dd9afd8214aa",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 49196554,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "8536.177048 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-05T20:05:27",
  "trx_id": "88237a46df2068fc7e9567a01856ce65e057c871",
  "trx_in_block": 12,
  "virtual_op": 0
}

{
  "block": 48270821,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "1920.017158 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-11-03T02:41:48",
  "trx_id": "cf27c64000264ca99f34822015d8d034b580f042",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 43223319,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "8738.982407 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-09T11:06:18",
  "trx_id": "c53d152feb48a78141c74833a9a422ec625a9854",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 43200367,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "1953.311140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-08T15:30:51",
  "trx_id": "2d436a2e6cfb252f3ce7443a03d0c9b81dbec9e4",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 38160305,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @seobangnim! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@seobangnim/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@seobangnim) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=seobangnim)_</sub>\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql-regexp",
      "permlink": "steemitboard-notify-seobangnim-20191114t063206000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-11-14T06:32:06",
  "trx_id": "f61d37bcddbe2bf05aa8e18578d03020209b7eb4",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 35339870,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "8896.556630 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-08-07T09:12:24",
  "trx_id": "e3c3915f1f9032366a0ad230b9a59759c5d11421",
  "trx_in_block": 20,
  "virtual_op": 0
}

{
  "block": 27684920,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @seobangnim! You have received a personal award!\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/@seobangnim/birthday1.png)](http://steemitboard.com/@seobangnim)  1 Year on Steemit\n<sub>_Click on the badge to view your Board of Honor._</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/steemfest/@steemitboard/the-meet-the-steemians-contest-is-over-results-are-coming-soon\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmeLukvNFRsa7RURqsFpiLGEZZD49MiU52JtWmjS5S2wtW/image.png\"></a></td><td><a href=\"https://steemit.com/steemfest/@steemitboard/the-meet-the-steemians-contest-is-over-results-are-coming-soon\">The Meet the Steemians Contest is over - Results are coming soon ...</a></td></tr></table>\n\n> Support [SteemitBoard's project](https://steemit.com/@steemitboard)! **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql-regexp",
      "permlink": "steemitboard-notify-seobangnim-20181114t060830000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-11-14T06:08:30",
  "trx_id": "49f06316c7b470beb3213435f15599724170643b",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 25285098,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "9095.047594 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-08-22T07:52:24",
  "trx_id": "00c5296ae9a0acc7f6552c1f6fccc912af526de1",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 22685431,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @seobangnim! You have completed some achievement on Steemit and have been rewarded with new badge(s) :\n\n[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/voted.png)](http://steemitboard.com/@seobangnim) Award for the number of upvotes received\n\nClick on any badge to view your own Board of Honor on SteemitBoard.\nFor more information about SteemitBoard, click [here](https://steemit.com/@steemitboard)\n\nIf you no longer want to receive notifications, reply to this comment with the word `STOP`\n\n> Do you like **SteemitBoard**'s project? **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql-regexp",
      "permlink": "steemitboard-notify-seobangnim-20180523t151853000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T15:18:51",
  "trx_id": "92e8e037532b83a00657c5a4e273057abd3dca92",
  "trx_in_block": 41,
  "virtual_op": 0
}

{
  "block": 22676348,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "regexp 란?\n\nlike 검색과는 달리 정규식을 이용한 검색 방식을 말한다.\nregexp는 우리에게 like보다 좀 더 다양한 검색을 할 수 있도록 도움을 준다.\n(관련 URL : http://dev.mysql.com/doc/refman/5.1/en/regexp.html )\n\n\nregexp 를 이용한 검색의 예제\n```\nselect * from test where name regexp '가'\n```\nname 필드에 '가'를 포함한 모든 레코드를 출력한다.\n(select * from test where name like '%가%') 의 쿼리와 동일하다\n```\nselect * from test where name regexp '가|나|다|라'\n```\nname 필드에 가 또는 나 또는 다 또는 라 를 포함한 레코드를 모두 출력한다.\n(select * from test where name like '%가%' or name like '%나%' or name like '%다%' or name like '%라%') 쿼리와 동일\n```\nselect * from test where name regexp '[가-힇]'\n```\nname 필드에 한글이 포함된 모든 레코드를 검색한다.\n```\nselect * from test where name regexp '^[가-힇]+$'\n```\nname 필드에 한글로만 구성된 모든 레코드를 검색한다.\n\n\nregexp 정규식 기호에 대한 간단한 소개\n```\n. : 문자 하나를 나타낸다.\n* : 앞에 나온 문자의 0개 이상 반복을 나타낸다.\n^ : 문자열의 처음을 나타낸다.\n$ : 문자열의 끝을 나타낸다.\n[.] : 괄호 안의 문자열 일치를 확인한다.\n{.} : 반복을 나타낸다.\n| : or 를 나타낸다.\n```\n* 참고사항\n정규식의 검색을 이용할때 절대 사용자에게 정규식 기능을 제공해선 안된다.\n각 종 오류를 포함할 수 있고 sql 인젝션에 취약해지기 때문에\n정규식의 검색을 개발자가 미리 정한 테두리 안에서 행해져야 한다.",
      "json_metadata": "{\"tags\":[\"mysql\",\"regexp\",\"search\"],\"links\":[\"http://dev.mysql.com/doc/refman/5.1/en/regexp.html\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "mysql-regexp",
      "title": "[MySQL] 정규식을 이용한 검색 regexp"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:44:12",
  "trx_id": "ea7ac9c119ca60cf70b615ea828ec30563e98e7b",
  "trx_in_block": 40,
  "virtual_op": 0
}

{
  "block": 22676228,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "mysql-log-bin",
      "voter": "aliamuskan",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:38:12",
  "trx_id": "5d69d0522a18a302a21f659143faa09aec01044f",
  "trx_in_block": 51,
  "virtual_op": 0
}

{
  "block": 22676209,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "MySQL에서 사용하는 log-bin이라는 옵션은 사용된 쿼리들이 로깅되는 파일이며 Innodb 혹은 Replication등에서 사용되곤 합니다.\n\n하지만 이 파일의 문제는 무한정 늘어난다는 것입니다. relay-log-space-limit 같은 옵션이 있지만 이 옵션은 Replication에서 사용되는 relay-log-bin의 용량을 제한 하는 옵션이지 해결책이 되지 못합니다.\n\n하지만 이 파일을 정리하는 방법이 있습니다. 우선 다음의 Query를 사용하는 것입니다.\n\n```\nPURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)\n```\n\nINTERVAL에서는 원하시는 로깅 시점을 기록하시면 됩니다. 위의 경우에는 30일 이전의 로깅 정보를 삭제하게 됩니다.\n\n차례차례 해보도록 하겠습니다.\n\n1. 현재의 하드디스크 용량 상태를 확인합니다.\n```\n[root@Theeye db]# df -h\nFilesystem            Size  Used Avail Use% Mounted on\n/dev/sda1              18G  1.9G   15G  12% /\n/dev/sda3              15G  803M   13G   6% /home\n/dev/sda2              97G   78G   15G  85% /usr/local/mysql/db\n```\n\n데이터베이스 공간이 85%나 사용되어 곧 꽉찰지도 모른다는 불안감에 휩싸이게 되었습니다.\n\n2. log-bin 파일을 확인해 봅시다.\n```\n[root@Theeye db]# ls mysql-bin.*\nmysql-bin.000001  mysql-bin.000002  mysql-bin.000003 ......  mysql-bin.000073\n```\n파일이 엄청나게 많이 있습니다.\n\n3. 다음 명령어를 수행합니다.\n```\nmysql -e \"PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)\"\n```\n\n물론 mysql에 접속하셔서 위의 명령어를 입력하셔도 됩니다. Super권한을 가진 root계정으로 실행해 주세요.\n\n4. log-bin 파일이 줄었나 확인해 봅시다.\n```\n[root@Theeye db]# ls mysql-bin.*\nmysql-bin.000041  mysql-bin.000042  mysql-bin.000043 ......  mysql-bin.000073\n```\n\n41번 이전의 파일들이 모두 삭제 되었습니다. 41번 부터가 최근 30일 이내의 로그정보가 남아있는 모양이군요.\n\n5. 하드디스크 용량 상태를 확인해 봅시다.\n```\n[root@Theeye db]# df -h\nFilesystem            Size  Used Avail Use% Mounted on\n/dev/sda1              18G  1.9G   15G  12% /\n/dev/sda3              15G  803M   13G   6% /home\n/dev/sda2              97G   40G   53G  43% /usr/local/mysql/db\n```\n\n확실히 용량이 많이 확보가 되었군요^^\n\n주기적인 실행이 필요하실 경우에는 위의 명령어를 crontab에 등록하시면 됩니다. 일주일에 한번정도의 실행이 적당하겠네요.",
      "json_metadata": "{\"tags\":[\"mysql\",\"log\",\"capacity\",\"decrease\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "mysql-log-bin",
      "title": "[MySQL] 무한정 늘어나는 log-bin 파일 줄이기"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:37:15",
  "trx_id": "67a55eb7e130fc452aafc187361463a004bca27f",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 22676006,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "7wevom-mysql",
      "voter": "originalworks",
      "weight": 200
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:27:03",
  "trx_id": "e07ec962efb85bf100425fcf595786dd1b4abde8",
  "trx_in_block": 41,
  "virtual_op": 0
}

{
  "block": 22675975,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "가령 다음과 같은 테이블이 있는 경우:\nid|name\n- | -\n1|google\n2|yahoo\n3|msn\n4|google\n5|google\n6|yahoo\n\n중복되는 필드 중에서 가장 낮은 ID만 남기고 모두 삭제하고 싶은 경우가 있을 수 있습니다. (혹은 그 반대로 가장 큰 ID만 남겨야 하는 경우도 있을 것입니다.)\n\n이런 상황에서 다음과 같은 쿼리를 사용할 수 있습니다.\n```\nDELETE n1 FROM tableName n1, tableName n2 WHERE n1.id > n2.id AND n1.name = n2.name\n```\n큰 ID를 남기려는 경우에는:\n```\nDELETE n1 FROM tableName n1, tableName n2 WHERE n1.id < n2.id AND n1.name = n2.name\n```\n참고로 여러 개의 row를 삭제하려는 경우에는 다음과 같이 IN statement를 사용하면 됩니다.\n```\nDELETE from tablename WHERE id IN (1,2,3,...,254);\n```\n\nBetween을 사용하여 범위를 지정하는 것도 가능합니다.\n```\nDELETE from tablename WHERE id BETWEEN 1 AND 254;\n```",
      "json_metadata": "{\"tags\":[\"mysql\",\"duplicate\",\"rows\",\"delete\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "7wevom-mysql",
      "title": "[MySQL] 중복되는 행을 하나만 남기도 모두 삭제하는 방법"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:25:30",
  "trx_id": "e9c703b83350d60adfb00f5dffac47db58b60c6f",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 22675946,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "7wevom-mysql",
      "voter": "ubg",
      "weight": 100
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:24:03",
  "trx_id": "f07647ebbd7104843d00765622e049a8d7316b34",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 22675935,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "7wevom-mysql",
      "voter": "kriptojon",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:23:30",
  "trx_id": "0a87451d33f4c4bae89e61ed35eb521d58f2c8f2",
  "trx_in_block": 71,
  "virtual_op": 0
}

{
  "block": 22675932,
  "op": [
    "comment",
    {
      "author": "somesteamer",
      "body": "Excellent post!",
      "json_metadata": "{\"tags\":[\"mysql\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "seobangnim",
      "parent_permlink": "7wevom-mysql",
      "permlink": "re-seobangnim-7wevom-mysql-20180523t072248192z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:23:21",
  "trx_id": "24c871a3ce6961e664866600745134b598b7ed10",
  "trx_in_block": 54,
  "virtual_op": 0
}

{
  "block": 22675925,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "가령 다음과 같은 테이블이 있는 경우:\nid|name\n- | -\n1|google\n2|yahoo\n3|msn\n4|google\n5|google\n6|yahoo\n\n중복되는 필드 중에서 가장 낮은 ID만 남기고 모두 삭제하고 싶은 경우가 있을 수 있습니다. (혹은 그 반대로 가장 큰 ID만 남겨야 하는 경우도 있을 것입니다.)\n\n이런 상황에서 다음과 같은 쿼리를 사용할 수 있습니다.\n```\nDELETE n1 FROM tableName n1, tableName n2 WHERE n1.id > n2.id AND n1.name = n2.name\n```\n큰 ID를 남기려는 경우에는:\n```\nDELETE n1 FROM tableName n1, tableName n2 WHERE n1.id < n2.id AND n1.name = n2.name\n```\n참고로 여러 개의 row를 삭제하려는 경우에는 다음과 같이 IN statement를 사용하면 됩니다.\n```\nDELETE from tablename WHERE id IN (1,2,3,...,254);\n```\n\nBetween을 사용하여 범위를 지정하는 것도 가능합니다.\n```\nDELETE from tablename WHERE id BETWEEN 1 AND 254;\n```",
      "json_metadata": "{\"tags\":[\"mysql\",\"duplicate\",\"rows\",\"delete\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "7wevom-mysql",
      "title": "[MySQL] 중복되는 행을 하나만 남기도 모두 삭제하는 방법"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:23:00",
  "trx_id": "a938170b489ea9e97dac9ea059e7ecc576808c0a",
  "trx_in_block": 43,
  "virtual_op": 0
}

{
  "block": 22675579,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "@@ -68,104 +68,79 @@\n Name\n-   id  \n+%7Cid%7C\n Col1\n-  \n+%7C\n Col2%0A\n-Row1   1    6     1%0ARow2   2    2     3%0ARow3   3    9     5%0ARow4   4    16    \n+- %7C - %7C - %7C -%0ARow1%7C1%7C6%7C1%0ARow2%7C2%7C2%7C3%0ARow3%7C3%7C9%7C5%0ARow4%7C4%7C16%7C\n 8%0A%0A%EB%8B%A4\n@@ -169,17 +169,20 @@\n %EB%A0%A4%EA%B3%A0 %ED%95%9C%EB%8B%A4%EB%A9%B4?%0A\n+%60%60%60\n %0A\n-\n UPDATE t\n@@ -375,17 +375,20 @@\n id = 4;%0A\n+%60%60%60\n %0A\n-\n %EB%AC%B8%EC%A0%9C %ED%95%B4%EA%B2%B0!%0A%0A\n@@ -438,17 +438,20 @@\n .%0A%0A%EC%98%88%EC%A0%9C :%0A\n+%60%60%60\n %0A\n-\n INSERT I\n@@ -577,17 +577,20 @@\n (Col2);%0A\n+%60%60%60\n %0A\n-\n %EC%9C%84 %EB%AC%B8%EC%A0%9C%EC%97%90 %EB%8C%80%ED%95%9C\n@@ -595,17 +595,20 @@\n %EB%8C%80%ED%95%9C %ED%95%B4%EA%B2%B0%EC%9D%80?%0A\n+%60%60%60\n %0A\n-\n UPDATE t\n@@ -1043,16 +1043,19 @@\n  3, 4);%0A\n+%60%60%60\n %0A%EC%9C%84 %EB%B0%A9%EB%B2%95%EC%9C%BC%EB%A1%9C \n",
      "json_metadata": "{\"tags\":[\"mysql\",\"multi\",\"update\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "mysql",
      "title": "MySQL의 다중 업데이트"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:05:39",
  "trx_id": "f405043a191ac8e34bd9223410114a9ad8c4bb91",
  "trx_in_block": 39,
  "virtual_op": 0
}

{
  "block": 22675526,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "mysql-rename-table",
      "voter": "swagger",
      "weight": 2
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:03:00",
  "trx_id": "02fcc02218859fe040c5791c08db68a4ef11af36",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 22675519,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "65bjv6-mysql",
      "voter": "swagger",
      "weight": 2
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:02:39",
  "trx_id": "36dc3dddad1e15ea47b7c41f4107244236d539ac",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 22675505,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "@@ -27,16 +27,19 @@\n %ED%85%8C%EC%9D%B4%EB%B8%94%EB%AA%85 : %0A\n+%60%60%60\n %0Amysql %3E\n@@ -85,16 +85,19 @@\n test : %0A\n+%60%60%60\n %0A=%3E %ED%85%8C%EC%9D%B4%EB%B8%94 \n",
      "json_metadata": "{\"tags\":[\"mysql\",\"rename\",\"table\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "mysql-rename-table",
      "title": "[MySQL] 테이블의 이름 변경하기 - rename table"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:01:57",
  "trx_id": "beeb4b140c884e7e1cda965651790f48d9af0afa",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 22675491,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "@@ -75,16 +75,20 @@\n %EB%8B%A4.. %E3%85%8E%E3%85%8E%0A%0A\n+%60%60%60%0A\n SELECT%0AS\n@@ -221,16 +221,20 @@\n 99426')%0A\n+%60%60%60%0A\n --------\n@@ -294,18 +294,8 @@\n ----\n-%0AMysql %EB%B0%A9%EB%B2%952\n %0A%0A%EC%A0%84%EC%B2%B4\n@@ -330,16 +330,20 @@\n %EC%9E%90%EC%97%B4%EA%B0%AF%EC%88%98%EB%A5%BC %EB%BA%8C%0A\n+%60%60%60%0A\n CREATE F\n@@ -607,16 +607,20 @@\n  table;%0A\n+%60%60%60%0A\n --------\n@@ -684,16 +684,20 @@\n %0AMS-SQL%0A\n+%60%60%60%0A\n CREATE F\n@@ -904,195 +904,41 @@\n END%0A\n-%0A/********************************************************************************%0A** 1%EC%B0%A8 %EC%B9%B4%ED%85%8C%EA%B3%A0%EB%A6%AC%EA%B0%80 %EB%88%84%EB%9D%BD%EB%90%9C %EB%8D%B0%EC%9D%B4%ED%84%B0 %EC%A1%B0%ED%9A%8C%0A********************************************************************************/\n+%60%60%60%0A%3Cbr%3E%0A%0A1%EC%B0%A8 %EC%B9%B4%ED%85%8C%EA%B3%A0%EB%A6%AC%EA%B0%80 %EB%88%84%EB%9D%BD%EB%90%9C %EB%8D%B0%EC%9D%B4%ED%84%B0 %EC%A1%B0%ED%9A%8C%0A%60%60%60\n %0ASel\n@@ -1575,8 +1575,12 @@\n '%0A) As A\n-\n \n+%0A%60%60%60\n",
      "json_metadata": "{\"tags\":[\"mysql\",\"char\",\"count\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "65bjv6-mysql",
      "title": "[MySQL] 특정 문자 개수 세기"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T07:01:15",
  "trx_id": "353fe667d3d323da7194fc6076ce8e4b5cc4cf7b",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 22675148,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "65bjv6-mysql",
      "voter": "originalworks",
      "weight": 200
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T06:44:06",
  "trx_id": "4d5513e78a05d800014bdfcdcbdf56b4d8d0f7b9",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 22675117,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "문자열 컬럼내 '@'의 갯수를 알아내려고 찾았을때  아래 구문을 쓰는 내용을 보았다.\n정말이지 대한민국은 머리 좋은 사람이 많은것 같다.. ㅎㅎ\n\nSELECT\nSUM((CHAR_LENGTH(Paper_list)-CHAR_LENGTH(REPLACE(Paper_list,'@',''))+1))\nFROM T_NewsInfo WHERE Notice_Number IN ('0999427', '0999426')\n-----------------------------------------------------------------\nMysql 방법2\n\n전체문자갯수에서 찾고자하는 문자열을 공백으로 처리한 문자열갯수를 뺌\nCREATE FUNCTION getStrCount ( inputdata varchar(250), searchStr varchar(250) )\nRETURNS int\nBEGIN\n    declare q int;\n    set q = char_length(inputdata) - char_length(replace(inputdata,searchStr,'');\n    RETURN(q);\nEND\nselect getStrCount (필드 또는 문자열,'찾고자 하는 문자열') from table;\n-----------------------------------------------------------------\nMS-SQL\nCREATE FUNCTION getStrCount (@inputdata nvarchar(max), @searchStr nvarchar(max) )\nRETURNS int\nAS\nBEGIN\n    DECLARE @q int\n    SET @q = LEN(@inputdata) - LEN(REPLACE(@inputdata, @searchStr, ''))\n    RETURN @q\nEND\n\n/********************************************************************************\n** 1차 카테고리가 누락된 데이터 조회\n********************************************************************************/\nSelect goodsno\n        , Left(category, 3) As 'depth1'\n\t, Group_Concat(category) As 'cate'\n\t, Max(Length(category)) / 3 As 'max_depth'\nFrom gd_goods_link\nWhere Left(category, 3) = '005'\nGroup By goodsno, Left(category, 3)\nHaving Left(cate, 4) <> depth1+','\nSelect goodsno, depth1, cate, max_depth\n\t, Sum((Char_Length(cate)-Char_Length(Replace(cate,',',''))+1)) -- 콤마 개수\nFrom (\n\tSelect goodsno\n\t\t, Left(category, 3) As 'depth1'\n\t\t, Group_Concat(category) As 'cate'\n\t\t, Max(Length(category)) / 3 As 'max_depth'\n\tFrom gd_goods_link\n\tWhere Left(category, 3) = '005'\n\tGroup By goodsno, Left(category, 3)\n\tHaving Left(cate, 4) <> depth1+','\n) As A",
      "json_metadata": "{\"tags\":[\"mysql\",\"char\",\"count\"],\"users\":[\"inputdata\",\"searchstr\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "65bjv6-mysql",
      "title": "[MySQL] 특정 문자 개수 세기"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-23T06:42:33",
  "trx_id": "e55ce0170c53038250726d1e068ccc22873cd059",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 22620945,
  "op": [
    "comment",
    {
      "author": "imperialdynasty",
      "body": "Thank you!",
      "json_metadata": "{\"tags\":[\"mysql\"],\"community\":\"busy\",\"app\":\"busy/2.4.0\"}",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql",
      "permlink": "re-seobangnim-mysql-20180517t235619204z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-21T09:33:18",
  "trx_id": "11ef68555744cc8a2ab4c24dcd6f04b2033809d3",
  "trx_in_block": 26,
  "virtual_op": 0
}

{
  "block": 22548108,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "29492.456083 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-18T20:50:51",
  "trx_id": "40a2af698f38196e95922d1b1bb91629874e645e",
  "trx_in_block": 38,
  "virtual_op": 0
}

{
  "block": 22539072,
  "op": [
    "comment",
    {
      "author": "arcange",
      "body": "**WARNING** - The message you received from @imperialdynasty is a **CONFIRMED SCAM!**\n**DO NOT FOLLOW** any instruction and **DO NOT CLICK** on any link in the comment!\n\nFor more information, read this post: \nhttps://steemit.com/steemit/@arcange/phishing-site-reported-postupper-dot-ml\n\nIf you find my work to protect you and the community valuable, please consider to upvote this warning or to [vote for my witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=arcange&approve=1).",
      "json_metadata": "{\"image\":[\"http://i.cubeupload.com/d1Dr28.png\"]}",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql",
      "permlink": "re-mysql-20180518t151859000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-18T13:18:57",
  "trx_id": "4afb730248a3b61a28c834f8a36d6bb7cf443ee2",
  "trx_in_block": 49,
  "virtual_op": 0
}

{
  "block": 22524938,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "rename table 현재테이블명 to 변경할테이블명 : \n\nmysql > rename table seobangnim to seobangnim_test : \n\n=> 테이블 seobangnim 을 seobangnim_test 로 수정한다.",
      "json_metadata": "{\"tags\":[\"mysql\",\"rename\",\"table\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "mysql-rename-table",
      "title": "[MySQL] 테이블의 이름 변경하기 - rename table"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-18T01:32:12",
  "trx_id": "70d8f881c5e2e494bd9037e9c3b545212897f4d6",
  "trx_in_block": 50,
  "virtual_op": 0
}

{
  "block": 22523795,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "mysql",
      "voter": "decayboy",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-18T00:35:00",
  "trx_id": "4709d224834d8fdd920be80fccd76295c09d03f0",
  "trx_in_block": 23,
  "virtual_op": 0
}

{
  "block": 22523032,
  "op": [
    "comment",
    {
      "author": "imperialdynasty",
      "body": "## More Than you Can Think\nGet 20 upvotes and 10 followers only for join the site.\nThe 20 upvotes worth 1SBD so why wait get it quickly before the campaign over.\n[CLICK HERE TO JOIN](https://hidereferrer.com/lf/01697c)",
      "json_metadata": "{\"tags\":[\"mysql\"],\"links\":[\"https://hidereferrer.com/lf/01697c\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql",
      "permlink": "re-seobangnim-mysql-20180517t235619204z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:56:48",
  "trx_id": "7a7a24530b4fb9915318d4b41bd7d37a06792886",
  "trx_in_block": 30,
  "virtual_op": 0
}

{
  "block": 22523029,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "mysql",
      "voter": "ax3",
      "weight": 100
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:56:39",
  "trx_id": "1b41c343c53257dd41247a2ff7ecb3a0685bc6e1",
  "trx_in_block": 18,
  "virtual_op": 0
}

{
  "block": 22523029,
  "op": [
    "comment",
    {
      "author": "introduce.bot",
      "body": "✅  @seobangnim, I gave you an upvote on your first post! **Please give me a follow** and I will give you a follow in return!<br><br>Please also take a moment to read [this post](https://steemit.com/spam/@pleasestop/introducing-pleasestop-here-to-reduce-comment-spam) regarding bad behavior on Steemit.",
      "json_metadata": "",
      "parent_author": "seobangnim",
      "parent_permlink": "mysql",
      "permlink": "introduce-bot-re-seobangnimmysql",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:56:39",
  "trx_id": "f0b38610ea2be30095a34f2a007158d05855b5f3",
  "trx_in_block": 9,
  "virtual_op": 0
}

{
  "block": 22523028,
  "op": [
    "vote",
    {
      "author": "seobangnim",
      "permlink": "mysql",
      "voter": "introduce.bot",
      "weight": 62
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:56:36",
  "trx_id": "3697b95e276ee9d278f65b5d3c69aadf5a8735e7",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 22523026,
  "op": [
    "comment",
    {
      "author": "seobangnim",
      "body": "한 번에 여러 행을 MySQL에서 업데이트하는 방법이 있을까?\n\n예를 들어 나는 다음과 같은 테이블 구조가 있을 때,\n\nName   id  Col1  Col2\nRow1   1    6     1\nRow2   2    2     3\nRow3   3    9     5\nRow4   4    16    8\n\n다음의 5가지 쿼리를 하나의 쿼리로 결합하려고 한다면?\n\nUPDATE table SET Col1 = 1 WHERE id = 1;\nUPDATE table SET Col1 = 2 WHERE id = 2;\nUPDATE table SET Col2 = 3 WHERE id = 3;\nUPDATE table SET Col1 = 10 WHERE id = 4;\nUPDATE table SET Col2 = 12 WHERE id = 4;\n\n문제 해결!\n\nINSERT ... ON DUPLICATE KEY UPDATE 를 사용해 보자.\n\n예제 :\n\nINSERT INTO table (id,Col1,Col2) VALUES (1,1,1),(2,2,3),(3,9,3),(4,10,12)\nON DUPLICATE KEY UPDATE Col1=VALUES(Col1),Col2=VALUES(Col2);\n\n위 문제에 대한 해결은?\n\nUPDATE table SET Col1 = CASE id \n                          WHEN 1 THEN 1 \n                          WHEN 2 THEN 2 \n                          WHEN 4 THEN 10 \n                          ELSE Col1 \n                        END, \n                 Col2 = CASE id \n                          WHEN 3 THEN 3 \n                          WHEN 4 THEN 12 \n                          ELSE Col2 \n                        END\n             WHERE id IN (1, 2, 3, 4);\n\n위 방법으로 1개 쿼리로 다중 업데이트를 진행할 수 있다!",
      "json_metadata": "{\"tags\":[\"mysql\",\"multi\",\"update\"],\"app\":\"steemit/0.1\",\"format\":\"markdown\"}",
      "parent_author": "",
      "parent_permlink": "mysql",
      "permlink": "mysql",
      "title": "MySQL의 다중 업데이트"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:56:30",
  "trx_id": "ffe34fa92e64f47db308fb49d4b553d3b5878d28",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 22522832,
  "op": [
    "account_update",
    {
      "account": "seobangnim",
      "json_metadata": "{\"profile\":{\"name\":\"서방님\",\"profile_image\":\"https://steemitimages.com/DQmTDU6zBWdgN94h7FWzBoHfXSRAxMwepmqZ7psu4Ak7KnW/superman.png\"}}",
      "memo_key": "STM6M92LF19Nmko1Sn18PuS3NVUbf8cQ7fMJhaeXTTnvGJ1mfY4PG"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:46:48",
  "trx_id": "f74abf83d75eaa910ce647afd9dde6644a9f0253",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 22522801,
  "op": [
    "account_update",
    {
      "account": "seobangnim",
      "json_metadata": "{\"profile\":{\"name\":\"서방님\"}}",
      "memo_key": "STM6M92LF19Nmko1Sn18PuS3NVUbf8cQ7fMJhaeXTTnvGJ1mfY4PG"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T23:45:15",
  "trx_id": "2b4331b6c02ebda0a78773be9b649a1fc1385e8f",
  "trx_in_block": 10,
  "virtual_op": 0
}

{
  "block": 22497559,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "9147.001760 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-17T02:42:57",
  "trx_id": "913a65a681f230af0083daef495be0719e2e8d58",
  "trx_in_block": 15,
  "virtual_op": 0
}

{
  "block": 21771334,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "29535.104106 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-21T20:52:18",
  "trx_id": "e812b50c8dfa85ca9e68258afff7135032493eda",
  "trx_in_block": 57,
  "virtual_op": 0
}

{
  "block": 18032617,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "seobangnim",
      "delegator": "steem",
      "vesting_shares": "29738.936158 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-12-12T22:21:42",
  "trx_id": "03fb3a66df82b6432ffc8241c73e138bd4e62bba",
  "trx_in_block": 17,
  "virtual_op": 0
}

{
  "block": 17205825,
  "op": [
    "account_create_with_delegation",
    {
      "active": {
        "account_auths": [],
        "key_auths": [
          [
            "STM57pEPvnQFjAQfgkVDnTJ2rkKonAdEQm77cNXzC2uDMxktnXxRY",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "creator": "steem",
      "delegation": "57000.000000 VESTS",
      "extensions": [],
      "fee": "0.500 STEEM",
      "json_metadata": "",
      "memo_key": "STM6M92LF19Nmko1Sn18PuS3NVUbf8cQ7fMJhaeXTTnvGJ1mfY4PG",
      "new_account_name": "seobangnim",
      "owner": {
        "account_auths": [],
        "key_auths": [
          [
            "STM6rcKpszx7VHhXqL3RS4bg3oTftBq6Jcmxbt1Bjs7Bwkw8dPS9H",
            1
          ]
        ],
        "weight_threshold": 1
      },
      "posting": {
        "account_auths": [],
        "key_auths": [
          [
            "STM4yApsH747vfqQ5b38HdHtsc1A675QtMSgK1sb5H4VFf4EgZQP8",
            1
          ]
        ],
        "weight_threshold": 1
      }
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2017-11-14T05:04:09",
  "trx_id": "bb100188bf43049f55b3ec7c75e61a833e53b97d",
  "trx_in_block": 20,
  "virtual_op": 0
}