Adding Update changeset in dml format updated value get by select query

up vote
0
down vote

favorite

I want to add changeset to update the table column value in yaml format and updated value is fetched at runtime via select query;

UPDATE table SET groupid=(select id from group where groupname='star') WHERE studentid=(select studentid from student where name ='abc');

yaml format

 - changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   value: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

but it is not working for me

edited Nov 21 at 9:33

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

yes liquibase changeset in yaml format
– Saakshi Aggarwal
Nov 21 at 9:34

add a comment |

up vote
0
down vote

favorite

I want to add changeset to update the table column value in yaml format and updated value is fetched at runtime via select query;

UPDATE table SET groupid=(select id from group where groupname='star') WHERE studentid=(select studentid from student where name ='abc');

yaml format

 - changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   value: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

but it is not working for me

edited Nov 21 at 9:33

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

yes liquibase changeset in yaml format
– Saakshi Aggarwal
Nov 21 at 9:34

add a comment |

up vote
0
down vote

favorite

I want to add changeset to update the table column value in yaml format and updated value is fetched at runtime via select query;

UPDATE table SET groupid=(select id from group where groupname='star') WHERE studentid=(select studentid from student where name ='abc');

yaml format

 - changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   value: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

but it is not working for me

edited Nov 21 at 9:33

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

I want to add changeset to update the table column value in yaml format and updated value is fetched at runtime via select query;

UPDATE table SET groupid=(select id from group where groupname='star') WHERE studentid=(select studentid from student where name ='abc');

yaml format

 - changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   value: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

but it is not working for me

postgresql yaml liquibase

edited Nov 21 at 9:33

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

edited Nov 21 at 9:33

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

edited Nov 21 at 9:33

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

asked Nov 21 at 8:37

Saakshi Aggarwal

2091518

yes liquibase changeset in yaml format
– Saakshi Aggarwal
Nov 21 at 9:34

add a comment |

yes liquibase changeset in yaml format
– Saakshi Aggarwal
Nov 21 at 9:34

yes liquibase changeset in yaml format
– Saakshi Aggarwal
Nov 21 at 9:34

add a comment |

1 Answer
1

active

oldest

votes

up vote
0
down vote

I get the answer

- changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   valueComputed: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

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',
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53408072%2fadding-update-changeset-in-dml-format-updated-value-get-by-select-query%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
0
down vote

I get the answer

- changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   valueComputed: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

add a comment |

up vote
0
down vote

I get the answer

- changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   valueComputed: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

add a comment |

up vote
0
down vote

I get the answer

- changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   valueComputed: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

I get the answer

- changeSet:

      id: 1

      author: abc

      changes:

         - update: 

             tableName: table

             columns:

               - column:

                   name: groupid

                   valueComputed: (select id from group where groupname='star')

             where: studentid=(select studentid from student where name ='abc')

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

answered Nov 21 at 10:30

Saakshi Aggarwal

2091518

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Htykuut