All Questions
306
questions
0
votes
1
answer
31
views
Stringified JSON data won't INSERT into mySQL(verified json format)
I'm not able to insert a JSON string into a mySQL table.
CREATE TABLE registered (
id int NOT NULL AUTO_INCREMENT,
name nvarchar(128) NOT NULL,
panels JSON NOT NULL,
PRIMARY KEY (id)
);...
1
vote
3
answers
472
views
MySQL error when inserting data into JSON column ER_INVALID_JSON_CHARSET
Last Saturday I've upgraded our database into MySQL 8 since AWS is deprecating 5.7.
Everything seemed to be working at first, but now we are seeing issues in our system.
I'm using expressJS & ...
0
votes
0
answers
82
views
How to update JSON value in mysql database using X Dev API for relational table
I am trying to emulate UPDATE user SET userDetails = JSON_SET(userDetails, '$.name', 'Alok') WHERE id = 1; to update JSON value using X Dev API.
var updateValue = `JSON_SET(userDetails, '$.name', '...
1
vote
1
answer
104
views
How to get rows as array of JSON object instead of array of array in MySQL X DevAPI select query?
I am using MySQL X DevAPI for relational tables in MySQL.
// Working with Relational Tables
var mysqlx = require('@mysql/xdevapi');
var myTable;
// Connect to server using a connection URL
mysqlx
....
0
votes
0
answers
36
views
Mysql can't update json for the first time
Router express
router.get("/winner", async function (req, res, next) {
let id = Number(req.query.id);
let fileUrlId = req.query.fileUrlId;
if (!id && !fileUrlId) {
return ...
0
votes
0
answers
32
views
Error when retrieving data from mysql in json format by the server
I connected the sql to the project, everything works fine, but when I try to retrieve the data and return the information in json format, I get an error
controllers
const {connection} = ...
0
votes
1
answer
32
views
iteration through JSON Object fails at TIMESTAMP
I want to get through all the JSON data which is presented by the MySQL(MariaDB) DB Response.
I found a function to iterate through to get & log the key:values pairs.
After that I want to send all ...
1
vote
2
answers
69
views
How to intersect mysql lines for a json file in nodejs
I would like to ask you for advice as I don't know which method to use:
For example with this query in Mysql i have this table:
user_Id
name
age
photo
1
Zack
23
Blob[2.1]
1
Zack
23
Blob[3.3]
1
...
-1
votes
1
answer
46
views
Failed to store JSON into MySQL
I would like to store this JSON into MySQL
{
"tokenId": 1,
"uri": "ipfs://baf...",
"minPrice": {
"type": "BigNumber",
...
-2
votes
1
answer
80
views
How can I store the data in arrow function?
Here is my arrow function I am storing in this let s arrow function,
which I stored inside of a loop and merged all object in object.assign. When I run the let s arrow function, however, I'm getting a ...
0
votes
1
answer
65
views
How can i update my JSON data in Post man?
I am working on the typescript and mysql rest api, here i am storing
data as json in database i could do inserted api but i couldn't
updated which i stored as json , here i have attached my api.
...
-2
votes
1
answer
84
views
Loop through the lines of a JSON file in javascript?
I have this JSON data here and I want to get all the data that corresponds to an id. EG: id 1 would contain service1 and 1.0. i need it to loop through however many lines there are and tell me the ...
1
vote
0
answers
132
views
Using Typescript api create an object in specific pattern from array of object, How can i retrive data using for loop in typescript?
Here I attached my typescript API using MySQL database, I have use foreach method for execute those two query because I need to get from those two query attached corresponding ID. So I need ...
0
votes
1
answer
157
views
How to send json data to my table in mysql database with nodejs
I know this is a general question, but I have the following code in my app.js
app.post('/data', (req, res) =>{
const file = req.files.filename;
const nose = [];
const filename = file....
0
votes
1
answer
1k
views
Typeorm query mysql json data column
How would you execute this query with typeorm?
SELECT * from t_integration_app WHERE settings = JSON_OBJECT("modelType", JSON_ARRAY("ACTION"));
I tried something like:
repository....