How to insert JSON data into a dynamic column MySQL?

Question

Im simply trying to insert json data into a dynamic column.

Data looks like follows:

"{"Fields": {
    "CompanyCode": "1",
    "FiscalYear": "2014",
    "CalYear": "2014",
    "CalPeriod": "1",
    "MinPostDate": "2014-01-14T00:00:00",
    "MaxPostDate": "2014-01-14T00:00:00",
    "CreditDebitInd": "H"
  }
}"

Query is like this:

 INSERT INTO jsontest (ID, Text) VALUES(DEFAULT, 'JsonHere');

ID is an ID which is the PK and it auto increments. Text is a BLOB

For INSERT, REPLACE, and UPDATE, if a generated column is inserted into, replaced, or updated explicitly, the only permitted value is DEFAULT.. See 13.1.18 CREATE TABLE Syntax :: CREATE TABLE and Generated Columns. — wchiquito
– wchiquito, Commented Mar 18, 2016 at 13:27
@wchiquito This literally has nothing to do with my question — Andrew Kilburn
– Andrew Kilburn, Commented Mar 18, 2016 at 14:14
When you talk about "dynamic column", you mean generated column? Otherwise, please add the structure of your table. — wchiquito
– wchiquito, Commented Mar 18, 2016 at 14:23
When I talk about a dynamic column, Im talking about a blob. I will update my question with the table structure now — Andrew Kilburn
– Andrew Kilburn, Commented Mar 18, 2016 at 14:24
What version of MySQL uses? Do you know 11.6 The JSON Data Type?, it can be useful. — wchiquito
– wchiquito, Commented Mar 18, 2016 at 14:30

Andrew Kilburn · Accepted Answer · 2016-03-18 14:36:38Z

2

INSERT INTO test VALUES(DEFAULT, '{"Fields": {
    "CompanyCode": "E009",
    "FiscalYear": "2014",
    "CalYear": "2014",
    "CalPeriod": "1",
    "MinPostDate": "2014-01-14T00:00:00",
    "MaxPostDate": "2014-01-14T00:00:00",
    "CreditDebitInd": "H"
  }
}');

I was using the ` symbol to encapsulate the data. It needs to be the ' symbol

answered Mar 18, 2016 at 14:36

Andrew Kilburn

2,2616 gold badges38 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert JSON data into a dynamic column MySQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related