JSON data type for like columnHow do you set a default value for a MySQL Datetime column?Which MySQL data type to use for storing boolean valuesShould I use the datetime or timestamp data type in MySQL?How do I change the data type for a column in MySQL?SQL select only rows with max value on a columnReference - What does this error mean in PHP?Storing JSON in database vs. having a new column for each keySELECT all and ORDER by Column A without duplicate of Column B and then ORDER by Column CINSERT INTO table SELECT & Append a columnIs the MySQL JSON data type bad for performance for data retrieval?
Sci fi short story, robot city that nags people about health
What are the penalties for overstaying in USA?
Can Ogre clerics use Purify Food and Drink on humanoid characters?
Why is the voltage measurement of this circuit different when the switch is on?
When to remove insignificant variables?
STM Microcontroller burns every time
What's currently blocking the construction of the wall between Mexico and the US?
Interaction between Leyline of Anticipation and Teferi, Time Raveler
Why do all the teams that I have worked with always finish a sprint without completion of all the stories?
Has there been any indication at all that further negotiation between the UK and EU is possible?
What is the legal status of travelling with methadone in your carry-on?
Apply brace expansion in "reverse order"
How would modern naval warfare have to have developed differently for battleships to still be relevant in the 21st century?
Trainee keeps missing deadlines for independent learning
How are the Zhentarim and Black Fist related?
Is my Rep in Stack-Exchange Form?
3D Crossword, Cryptic, Statue View & Maze
Find the diameter of a word graph
expiry or manufactured date?
C-152 carb heat on before landing in hot weather?
Does this Wild Magic result affect the sorcerer or just other creatures?
A STL-like vector implementation in C++
Why do textbooks often include the solutions to odd or even numbered problems but not both?
Can humans ever directly see a few photons at a time? Can a human see a single photon?
JSON data type for like column
How do you set a default value for a MySQL Datetime column?Which MySQL data type to use for storing boolean valuesShould I use the datetime or timestamp data type in MySQL?How do I change the data type for a column in MySQL?SQL select only rows with max value on a columnReference - What does this error mean in PHP?Storing JSON in database vs. having a new column for each keySELECT all and ORDER by Column A without duplicate of Column B and then ORDER by Column CINSERT INTO table SELECT & Append a columnIs the MySQL JSON data type bad for performance for data retrieval?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm trying to make like column.
like column is used when users like the content they push like button and users can do 1 like for 1 content.
So I decided to use JSON data type for like in order to prevent duplication of like.
but, here is my problem: I've read document, functions are seemed to be required original data as first parameter.
ex:)
mysql> SET @j = '"a": 1'; //this is original data
mysql> SELECT JSON_ARRAY_APPEND(@j, '$', 'z') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
If I want to add "b":2 then I need to fetch all json data, all I want to do is just push a data to it not fetching all json data from like column.
I want to do this :
mysql> SELECT database.table.`like`.JSON_ARRAY_APPEND('$', '"b":2') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
Let me know if you need more information.
Thanks.
mysql
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
add a comment |
I'm trying to make like column.
like column is used when users like the content they push like button and users can do 1 like for 1 content.
So I decided to use JSON data type for like in order to prevent duplication of like.
but, here is my problem: I've read document, functions are seemed to be required original data as first parameter.
ex:)
mysql> SET @j = '"a": 1'; //this is original data
mysql> SELECT JSON_ARRAY_APPEND(@j, '$', 'z') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
If I want to add "b":2 then I need to fetch all json data, all I want to do is just push a data to it not fetching all json data from like column.
I want to do this :
mysql> SELECT database.table.`like`.JSON_ARRAY_APPEND('$', '"b":2') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
Let me know if you need more information.
Thanks.
mysql
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
add a comment |
I'm trying to make like column.
like column is used when users like the content they push like button and users can do 1 like for 1 content.
So I decided to use JSON data type for like in order to prevent duplication of like.
but, here is my problem: I've read document, functions are seemed to be required original data as first parameter.
ex:)
mysql> SET @j = '"a": 1'; //this is original data
mysql> SELECT JSON_ARRAY_APPEND(@j, '$', 'z') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
If I want to add "b":2 then I need to fetch all json data, all I want to do is just push a data to it not fetching all json data from like column.
I want to do this :
mysql> SELECT database.table.`like`.JSON_ARRAY_APPEND('$', '"b":2') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
Let me know if you need more information.
Thanks.
mysql
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
I'm trying to make like column.
like column is used when users like the content they push like button and users can do 1 like for 1 content.
So I decided to use JSON data type for like in order to prevent duplication of like.
but, here is my problem: I've read document, functions are seemed to be required original data as first parameter.
ex:)
mysql> SET @j = '"a": 1'; //this is original data
mysql> SELECT JSON_ARRAY_APPEND(@j, '$', 'z') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
If I want to add "b":2 then I need to fetch all json data, all I want to do is just push a data to it not fetching all json data from like column.
I want to do this :
mysql> SELECT database.table.`like`.JSON_ARRAY_APPEND('$', '"b":2') as result;
+---------------------------------+
| result |
+---------------------------------+
| ["a": 1, "z"] |
+---------------------------------+
Let me know if you need more information.
Thanks.
mysql
mysql
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
asked Mar 25 at 9:34
JillAndMeJillAndMe
1481 silver badge10 bronze badges
1481 silver badge10 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
@JillAndMe! you can use the JSON_ARRAY_APPEND() method. I hope this will help you JSON_ARRAY_APPEND()
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55334808%2fjson-data-type-for-like-column%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
@JillAndMe! you can use the JSON_ARRAY_APPEND() method. I hope this will help you JSON_ARRAY_APPEND()
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
add a comment |
@JillAndMe! you can use the JSON_ARRAY_APPEND() method. I hope this will help you JSON_ARRAY_APPEND()
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
add a comment |
@JillAndMe! you can use the JSON_ARRAY_APPEND() method. I hope this will help you JSON_ARRAY_APPEND()
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
@JillAndMe! you can use the JSON_ARRAY_APPEND() method. I hope this will help you JSON_ARRAY_APPEND()
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
answered Mar 25 at 9:40
MKJMKJ
7681 gold badge11 silver badges27 bronze badges
7681 gold badge11 silver badges27 bronze badges
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55334808%2fjson-data-type-for-like-column%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
