How to add the same comment in the same Column name on different tables in the same db in SQL
0
I have a db with a lot of tables in it. Some of these tables have columns with the exact same name (e.g. comment_id).
Is there a way (in sql) to add the same comment to the column with the same name in different tables (in the same db).
Thank you very much in advance.
mysql sql
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
|
show 2 more comments
0
I have a db with a lot of tables in it. Some of these tables have columns with the exact same name (e.g. comment_id).
Is there a way (in sql) to add the same comment to the column with the same name in different tables (in the same db).
Thank you very much in advance.
mysql sql
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
Can you give an example? What have you tried so far?
– Sebastian Siemens
Nov 26 '18 at 12:14
Check for relationship between tables and insert based on Key
– iSahilSharma
Nov 26 '18 at 12:14
No.you could build alter statements for all tables via information.schema.columns
– P.Salmon
Nov 26 '18 at 12:18
Up until now I go to each table manually and add the comment. For example i go to the column example_id in sqlWorkBench , alter table and i add the comment in each table. The tables are around 200. and the column example_id is in all of them. I want to write a script to put the same comment in the same column.
– Filip123go
Nov 26 '18 at 12:20
If's it a comment_id, wouldn't that mean that there's some "Comments" table where those comments are stored? Then those records in the tables could point to the same comment_id ? (although that idea seems kinda weird i.m.h.o.)
– LukStorms
Nov 26 '18 at 12:21
|
show 2 more comments
0
0
0
I have a db with a lot of tables in it. Some of these tables have columns with the exact same name (e.g. comment_id).
Is there a way (in sql) to add the same comment to the column with the same name in different tables (in the same db).
Thank you very much in advance.
mysql sql
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
I have a db with a lot of tables in it. Some of these tables have columns with the exact same name (e.g. comment_id).
Is there a way (in sql) to add the same comment to the column with the same name in different tables (in the same db).
Thank you very much in advance.
mysql sql
mysql sql
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
asked Nov 26 '18 at 12:11
Filip123goFilip123go
74110
74110
Can you give an example? What have you tried so far?
– Sebastian Siemens
Nov 26 '18 at 12:14
Check for relationship between tables and insert based on Key
– iSahilSharma
Nov 26 '18 at 12:14
No.you could build alter statements for all tables via information.schema.columns
– P.Salmon
Nov 26 '18 at 12:18
Up until now I go to each table manually and add the comment. For example i go to the column example_id in sqlWorkBench , alter table and i add the comment in each table. The tables are around 200. and the column example_id is in all of them. I want to write a script to put the same comment in the same column.
– Filip123go
Nov 26 '18 at 12:20
If's it a comment_id, wouldn't that mean that there's some "Comments" table where those comments are stored? Then those records in the tables could point to the same comment_id ? (although that idea seems kinda weird i.m.h.o.)
– LukStorms
Nov 26 '18 at 12:21
|
show 2 more comments
Can you give an example? What have you tried so far?
– Sebastian Siemens
Nov 26 '18 at 12:14
Check for relationship between tables and insert based on Key
– iSahilSharma
Nov 26 '18 at 12:14
No.you could build alter statements for all tables via information.schema.columns
– P.Salmon
Nov 26 '18 at 12:18
Up until now I go to each table manually and add the comment. For example i go to the column example_id in sqlWorkBench , alter table and i add the comment in each table. The tables are around 200. and the column example_id is in all of them. I want to write a script to put the same comment in the same column.
– Filip123go
Nov 26 '18 at 12:20
If's it a comment_id, wouldn't that mean that there's some "Comments" table where those comments are stored? Then those records in the tables could point to the same comment_id ? (although that idea seems kinda weird i.m.h.o.)
– LukStorms
Nov 26 '18 at 12:21
Can you give an example? What have you tried so far?
– Sebastian Siemens
Nov 26 '18 at 12:14
Can you give an example? What have you tried so far?
– Sebastian Siemens
Nov 26 '18 at 12:14
Check for relationship between tables and insert based on Key
– iSahilSharma
Nov 26 '18 at 12:14
Check for relationship between tables and insert based on Key
– iSahilSharma
Nov 26 '18 at 12:14
No.you could build alter statements for all tables via information.schema.columns
– P.Salmon
Nov 26 '18 at 12:18
No.you could build alter statements for all tables via information.schema.columns
– P.Salmon
Nov 26 '18 at 12:18
Up until now I go to each table manually and add the comment. For example i go to the column example_id in sqlWorkBench , alter table and i add the comment in each table. The tables are around 200. and the column example_id is in all of them. I want to write a script to put the same comment in the same column.
– Filip123go
Nov 26 '18 at 12:20
Up until now I go to each table manually and add the comment. For example i go to the column example_id in sqlWorkBench , alter table and i add the comment in each table. The tables are around 200. and the column example_id is in all of them. I want to write a script to put the same comment in the same column.
– Filip123go
Nov 26 '18 at 12:20
If's it a comment_id, wouldn't that mean that there's some "Comments" table where those comments are stored? Then those records in the tables could point to the same comment_id ? (although that idea seems kinda weird i.m.h.o.)
– LukStorms
Nov 26 '18 at 12:21
If's it a comment_id, wouldn't that mean that there's some "Comments" table where those comments are stored? Then those records in the tables could point to the same comment_id ? (although that idea seems kinda weird i.m.h.o.)
– LukStorms
Nov 26 '18 at 12:21
|
show 2 more comments
0
active
oldest
votes
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
});
}
});
draft saved
draft discarded
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%2f53480876%2fhow-to-add-the-same-comment-in-the-same-column-name-on-different-tables-in-the-s%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53480876%2fhow-to-add-the-same-comment-in-the-same-column-name-on-different-tables-in-the-s%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
Can you give an example? What have you tried so far?
– Sebastian Siemens
Nov 26 '18 at 12:14
Check for relationship between tables and insert based on Key
– iSahilSharma
Nov 26 '18 at 12:14
No.you could build alter statements for all tables via information.schema.columns
– P.Salmon
Nov 26 '18 at 12:18
Up until now I go to each table manually and add the comment. For example i go to the column example_id in sqlWorkBench , alter table and i add the comment in each table. The tables are around 200. and the column example_id is in all of them. I want to write a script to put the same comment in the same column.
– Filip123go
Nov 26 '18 at 12:20
If's it a comment_id, wouldn't that mean that there's some "Comments" table where those comments are stored? Then those records in the tables could point to the same comment_id ? (although that idea seems kinda weird i.m.h.o.)
– LukStorms
Nov 26 '18 at 12:21