<div>
UPDATE TableFooFoo Set Column1=123,Column2='NewVa<wbr />lue2',Colu<wbr />mn3='NewFo<wbr />o' WHERE column3 = 'fool'<br />
<br />
(or WHERE columnGettingNewValue3 ='fool' depending what the table structure is)<br />
<br />
in short, you need to use UPDATE rather than INSERT, if I'm reading your question correctly
</div>


UPDATE TableFooFoo Set Column1=123,Column2='NewValue2',Column3='NewFoo' WHERE column3 = 'fool'

(or WHERE columnGettingNewValue3 ='fool' depending what the table structure is)

in short, you need to use UPDATE rather than INSERT, if I'm reading your question correctly

<div>
By I don't want to change the existing row, and instead I want to insert a copy of the row, with some fields being different.<br />
<br />
I also need a way to put the existing row value together with new field values.<br />

</div>


By I don't want to change the existing row, and instead I want to insert a copy of the row, with some fields being different.

I also need a way to put the existing row value together with new field values.


<div>
Thank you very much. &nbsp;That's what I'm looking for.
</div>


Thank you very much.  That's what I'm looking for.

<div>
<div class="content wysiwyg-content">
I'm trying to insert some existing row values, but with having some of the fields of different value.<br />
<br />
I have the below code, which is of course giving syntax error, but I'm not sure how to fix it.<br />
Can someone please point me in right direction?<br />
<br />
Thanks<br />

<pre><code id="code-602234">insert into TableFooFoo 
(column1, column2, column3, column4, columnGettingNewValue1, columnGettingNewValue2, columnGettingNewValue3)
 (
select column1, column2, column3, column4 from TableFooFoo where columnGettingNewValue3 = 'foo1' 
UNION 123, 'NewValue2', 'NewFoo'
);
</code></pre>
</div>
</div>


I'm trying to insert some existing row values, but with having some of the fields of different value.

I have the below code, which is of course giving syntax error, but I'm not sure how to fix it.
Can someone please point me in right direction?

Thanks

insert partial existing row data and fixed values into table

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.