<div>
What is the exact requirement ?<br />
You want shell script which will update mytable as mytable2 data or something else??
</div>


What is the exact requirement ?
You want shell script which will update mytable as mytable2 data or something else??

<div>
Why do you want to select something out of the database and then put it back? &nbsp;Do all the work in the database.<br />
<br />
FYI - I think your update should be:<br />

<pre><code id="code-20-42642234-1">UPDATE mytable1 
SET    my mytable1.value = 
       ( 
              SELECT value 
              FROM   mytable2 
              WHERE  mytable2.id=mytable1.id) 
WHERE  mytable1.id=1</code></pre>
You should use correlated subqueries.
</div>


Why do you want to select something out of the database and then put it back?  Do all the work in the database.

FYI - I think your update should be:


UPDATE mytable1 
SET    my mytable1.value = 
       ( 
              SELECT value 
              FROM   mytable2 
              WHERE  mytable2.id=mytable1.id) 
WHERE  mytable1.id=1

You should use correlated subqueries.

<div>
do you have common overlap?<br />
<br />
update table2 join table1 on table1.column1=tablet2.col<wbr />umna set table1.column2=table2.colu<wbr />mnb where condition.<br />
<br />
<br />
Seems like duplicative information,
</div>


do you have common overlap?

update table2 join table1 on table1.column1=tablet2.columna set table1.column2=table2.columnb where condition.


Seems like duplicative information,

<div>
<div class="content wysiwyg-content">
How I can I update a value I got from an Select query?<br />
<br />
Sample: Update mytable1 Set my mytable1.value = (Select value from mytable2 where mytable2.id=1) where mytable1.id=1<br />
And do not want to select. put in to a variable and write back to the db.<br />
<br />
I use a MySQL Database on Linux.
</div>
</div>


How I can I update a value I got from an Select query?

Sample: Update mytable1 Set my mytable1.value = (Select value from mytable2 where mytable2.id=1) where mytable1.id=1
And do not want to select. put in to a variable and write back to the db.

I use a MySQL Database on Linux.

MySqL Update value from Select

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.