Mysql insert with set and select





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I want to copy all records of one condition to new entries with other condition. in this example. i want to get all information of xxx=987 and add them with xxx=123 to the same table. So i want to copy some values, but not all into the new record.



INSERT table 

SET 

  pid = UPPER(UUID()),

  xxx = 123,

  (col1, col2) = (SELECT val1, val2 

                  FROM table

                  WHERE xxx = 987)


I tried many things, but it did not workout. any help highly appreciated
Best endo






mysql mysql-insert-id mysql-select-db







share|improve this question


















  • 1





    This question is similar to stackoverflow.com/questions/5391344/insert-with-select

    – Miguel Angel Alonso
    Jan 4 at 10:50











  • thanks, but i try to achieve this with an insert set statement

    – endo.anaconda
    Jan 4 at 11:48


















0















I want to copy all records of one condition to new entries with other condition. in this example. i want to get all information of xxx=987 and add them with xxx=123 to the same table. So i want to copy some values, but not all into the new record.



INSERT table 

SET 

  pid = UPPER(UUID()),

  xxx = 123,

  (col1, col2) = (SELECT val1, val2 

                  FROM table

                  WHERE xxx = 987)


I tried many things, but it did not workout. any help highly appreciated
Best endo






mysql mysql-insert-id mysql-select-db







share|improve this question


















  • 1





    This question is similar to stackoverflow.com/questions/5391344/insert-with-select

    – Miguel Angel Alonso
    Jan 4 at 10:50











  • thanks, but i try to achieve this with an insert set statement

    – endo.anaconda
    Jan 4 at 11:48














0












0








0








I want to copy all records of one condition to new entries with other condition. in this example. i want to get all information of xxx=987 and add them with xxx=123 to the same table. So i want to copy some values, but not all into the new record.



INSERT table 

SET 

  pid = UPPER(UUID()),

  xxx = 123,

  (col1, col2) = (SELECT val1, val2 

                  FROM table

                  WHERE xxx = 987)


I tried many things, but it did not workout. any help highly appreciated
Best endo






mysql mysql-insert-id mysql-select-db







share|improve this question














I want to copy all records of one condition to new entries with other condition. in this example. i want to get all information of xxx=987 and add them with xxx=123 to the same table. So i want to copy some values, but not all into the new record.



INSERT table 

SET 

  pid = UPPER(UUID()),

  xxx = 123,

  (col1, col2) = (SELECT val1, val2 

                  FROM table

                  WHERE xxx = 987)


I tried many things, but it did not workout. any help highly appreciated
Best endo






mysql mysql-insert-id mysql-select-db




mysql mysql-insert-id mysql-select-db






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Jan 4 at 10:40









endo.anacondaendo.anaconda

1,49842148




1,49842148








  • 1





    This question is similar to stackoverflow.com/questions/5391344/insert-with-select

    – Miguel Angel Alonso
    Jan 4 at 10:50











  • thanks, but i try to achieve this with an insert set statement

    – endo.anaconda
    Jan 4 at 11:48














  • 1





    This question is similar to stackoverflow.com/questions/5391344/insert-with-select

    – Miguel Angel Alonso
    Jan 4 at 10:50











  • thanks, but i try to achieve this with an insert set statement

    – endo.anaconda
    Jan 4 at 11:48








1




1





This question is similar to stackoverflow.com/questions/5391344/insert-with-select

– Miguel Angel Alonso
Jan 4 at 10:50





This question is similar to stackoverflow.com/questions/5391344/insert-with-select

– Miguel Angel Alonso
Jan 4 at 10:50













thanks, but i try to achieve this with an insert set statement

– endo.anaconda
Jan 4 at 11:48





thanks, but i try to achieve this with an insert set statement

– endo.anaconda
Jan 4 at 11:48












1 Answer
1






active

oldest

votes


















3














You seem to be looking for an INSERT ... SELECT query :



INSERT INTO table (pid, xxx, val1, val2)

SELECT UPPER(UUID()), 123, val1, val2

FROM table

WHERE xxx = 987;





share|improve this answer


























  • but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

    – endo.anaconda
    Jan 4 at 11:47






  • 1





    @endoanaconda : answer updated

    – GMB
    Jan 4 at 12:11











  • it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

    – endo.anaconda
    Jan 4 at 12:33











  • @endoanaconda ... SET is for UPDATE queries, not for INSERTs.

    – GMB
    Jan 4 at 12:56






  • 1





    @endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

    – Tarreq
    Jan 4 at 14:05












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


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54037336%2fmysql-insert-with-set-and-select%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









3














You seem to be looking for an INSERT ... SELECT query :



INSERT INTO table (pid, xxx, val1, val2)

SELECT UPPER(UUID()), 123, val1, val2

FROM table

WHERE xxx = 987;





share|improve this answer


























  • but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

    – endo.anaconda
    Jan 4 at 11:47






  • 1





    @endoanaconda : answer updated

    – GMB
    Jan 4 at 12:11











  • it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

    – endo.anaconda
    Jan 4 at 12:33











  • @endoanaconda ... SET is for UPDATE queries, not for INSERTs.

    – GMB
    Jan 4 at 12:56






  • 1





    @endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

    – Tarreq
    Jan 4 at 14:05
















3














You seem to be looking for an INSERT ... SELECT query :



INSERT INTO table (pid, xxx, val1, val2)

SELECT UPPER(UUID()), 123, val1, val2

FROM table

WHERE xxx = 987;





share|improve this answer


























  • but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

    – endo.anaconda
    Jan 4 at 11:47






  • 1





    @endoanaconda : answer updated

    – GMB
    Jan 4 at 12:11











  • it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

    – endo.anaconda
    Jan 4 at 12:33











  • @endoanaconda ... SET is for UPDATE queries, not for INSERTs.

    – GMB
    Jan 4 at 12:56






  • 1





    @endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

    – Tarreq
    Jan 4 at 14:05














3












3








3







You seem to be looking for an INSERT ... SELECT query :



INSERT INTO table (pid, xxx, val1, val2)

SELECT UPPER(UUID()), 123, val1, val2

FROM table

WHERE xxx = 987;





share|improve this answer















You seem to be looking for an INSERT ... SELECT query :



INSERT INTO table (pid, xxx, val1, val2)

SELECT UPPER(UUID()), 123, val1, val2

FROM table

WHERE xxx = 987;






share|improve this answer














share|improve this answer



share|improve this answer








edited Jan 4 at 12:10

























answered Jan 4 at 10:47









GMBGMB

22k61128




22k61128













  • but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

    – endo.anaconda
    Jan 4 at 11:47






  • 1





    @endoanaconda : answer updated

    – GMB
    Jan 4 at 12:11











  • it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

    – endo.anaconda
    Jan 4 at 12:33











  • @endoanaconda ... SET is for UPDATE queries, not for INSERTs.

    – GMB
    Jan 4 at 12:56






  • 1





    @endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

    – Tarreq
    Jan 4 at 14:05



















  • but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

    – endo.anaconda
    Jan 4 at 11:47






  • 1





    @endoanaconda : answer updated

    – GMB
    Jan 4 at 12:11











  • it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

    – endo.anaconda
    Jan 4 at 12:33











  • @endoanaconda ... SET is for UPDATE queries, not for INSERTs.

    – GMB
    Jan 4 at 12:56






  • 1





    @endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

    – Tarreq
    Jan 4 at 14:05

















but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

– endo.anaconda
Jan 4 at 11:47





but with this solution i need to provide all fields of the table, i want to submit only specific fields, the not mentioned fields will then be filled with default values of table

– endo.anaconda
Jan 4 at 11:47




1




1





@endoanaconda : answer updated

– GMB
Jan 4 at 12:11





@endoanaconda : answer updated

– GMB
Jan 4 at 12:11













it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

– endo.anaconda
Jan 4 at 12:33





it works, but i'd rather prefere to use INSERT with SET, since it is a bit more readable, if no better answer comes up, i think i go with your solution

– endo.anaconda
Jan 4 at 12:33













@endoanaconda ... SET is for UPDATE queries, not for INSERTs.

– GMB
Jan 4 at 12:56





@endoanaconda ... SET is for UPDATE queries, not for INSERTs.

– GMB
Jan 4 at 12:56




1




1





@endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

– Tarreq
Jan 4 at 14:05





@endo.anaconda Yes, Insert works with set , but you can't use "select" with that combination, you can do: INSERT INTO table SET xxx='yyy' , but you cant do: INSERT INTO table SET xxx='yyy' , col2 = (SELECT zzz FROM ......)

– Tarreq
Jan 4 at 14:05




















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














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54037336%2fmysql-insert-with-set-and-select%23new-answer', 'question_page');
}
);

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







-

Popular posts from this blog

Monofisismo

Image
Monofisismo (do grego: monos - "único, singular" e physis - "natureza") é o ponto de vista cristológico que defende que, depois da união do divino e do humano na encarnação histórica, Jesus Cristo, como encarnação do Filho ou Verbo ( Logos ) de Deus, teria apenas uma única "natureza", a divina, e não uma síntese de ambas. O monofisismo é contraposto pelo diofisismo (ou "diafisismo"), que defende que Jesus preservou em si as duas naturezas. Historicamente, o monofisismo se refere primordialmente à posição dos que (especialmente no Egito e, em menor grau, na Síria) rejeitaram as decisões do Concílio de Calcedônia em 451 (o quarto concílio ecumênico). Os membros mais moderados entre eles, porém, defendem a teologia "miafisita", que se tornou a oficial para as Igrejas Ortodoxas Orientais. Muitos ortodoxos orientais, porém, rejeitam essa classificação, mesmo como um termo genérico, mas ele é amplamente utilizado na literatura históri
Read more

Angular Downloading a file using contenturl with Basic Authentication

Image
0 I have a contentUrl when user clicks on that,file should be downloaded. If I try to browse the contentUrl in the browser it asks for Userid and password.I believe this is Basic Authentication.I dont want user to enter UserId and Password so I am passing it Authorization(Please see below code). Url looks some thing like this: http://XXX.XXX.XX.XXX:8080/flowable-rest/service/runtime/tasks/90875/attachments/90555/content let username : string = 'admin'; let pwd : string = 'test'; let headers = new Headers(); headers.set('Accept', 'text/json'); headers.append('Content-Type', 'application/json'); headers.set('Access-Control-Allow-Origin', '*'); headers.set('Access-Control-Allow-Methods','POST, GET, OPTIONS, PUT, DELETE'); head
Read more

Olmecas

Image
Monumento 1, uma das quatro cabeças colossais encontradas em La Venta, com altura aproximada de 3 metros Olmecas é a designação do povo e da civilização que estiveram na origem da antiga cultura pré-colombiana da Mesoamérica e que se desenvolveram nas regiões tropicais do centro-sul do atual México durante o pré-clássico, próximo de onde hoje estão localizados os estados mexicanos de Veracruz e Tabasco, no Istmo de Tehuantepec, numa zona designada área nuclear olmeca. A cultura olmeca floresceu nesta região aproximadamente entre 1500 e 400 a.C., [ 1 ] e crê-se que tenha sido a civilização-mãe de todas as civilizações mesoamericanas que se desenvolveram posteriormente. [ 2 ] No entanto, desconhece-se a sua exacta filiação étnica, ainda que existam numerosas hipóteses colocadas para tentar resolver esta questão. O etnónimo olmeca foi cunhado pelos arqueólogos do século XX, e não devem confundir-se com os muito posteriores olmecas-xicalancas que ocuparam vários locais do México
Read more