エラーに関してはJCON8-06のフラグがたっているか?(下記クエリ)
SELECT id
,CAST(MID(ITEM, 1, 1) as char) as KEY1
,CAST(MID(ITEM, 2, 1) as char) as X02
,CAST(MID(ITEM, 3, 1) as char) as X04
,CAST(MID(ITEM, 4, 1) as char) as TS051
,CAST(MID(ITEM, 5, 1) as char) as HS052
,CAST(MID(ITEM, 6, 1) as char) as TR053
,CAST(MID(ITEM, 7, 1) as char) as HR054
,CAST(MID(ITEM, 8, 1) as char) as X06
FROM `JCON`
WHERE CAST(MID(ITEM, 1, 1) as char) = 8
#JCON8
;
外すときは下記クエリ
UPDATE `JCON` SET ITEM=CONCAT(MID(ITEM,1,7),’0′,MID(ITEM,9))
WHERE CAST(MID(ITEM, 1, 1) as char) = 8;
2017/03/02
現状再現されないので保留中
エラーに関してはJCON8-06のフラグがたっているか?(下記クエリ)
SELECT id
,CAST(MID(ITEM, 1, 1) as char) as KEY1
,CAST(MID(ITEM, 2, 1) as char) as X02
,CAST(MID(ITEM, 3, 1) as char) as X04
,CAST(MID(ITEM, 4, 1) as char) as TS051
,CAST(MID(ITEM, 5, 1) as char) as HS052
,CAST(MID(ITEM, 6, 1) as char) as TR053
,CAST(MID(ITEM, 7, 1) as char) as HR054
,CAST(MID(ITEM, 8, 1) as char) as X06
FROM `JCON`
WHERE CAST(MID(ITEM, 1, 1) as char) = 8
#JCON8
;
外すときは下記クエリ
UPDATE `JCON` SET ITEM=CONCAT(MID(ITEM,1,7),’0′,MID(ITEM,9))
WHERE CAST(MID(ITEM, 1, 1) as char) = 8;
長い文字列の前と後ろが削れている -> これを直そうと思うと他とぶつかる?
CLEARのような指定や空白文字の上書きも存在しない