Hi all,
I want to update the same table.
like:::
earlier 4 columns are there in my table ‘example’ as::
col1,col2,col3,col4.
earlier i inserted data in these two columns col1,col2.
now based on column one, i want to update the table as::
set col1=‘new data’, col2=‘new data’,col3=‘earlier col1 data’,col4=‘earlier col2 data’.
means i want to move data from one col to another with new data and existing data…
Can any one help me regarding this?
Thanking you…
SET
col1 = 'new data'
, col2 = 'new data'
, col3 = col1
, col4 = col2
based on the value of col1, it will update.
If col2 is set, that value will be as col4 otherwise col4 as null…
What?
means condition is if value is equal to col1,then it will update like::;;
SQL>update example
set col1=‘new data’, col2=‘new data’,col3=‘earlier col1 data’,col4=‘earlier col2 data’ where col1=‘some text’;
UPDATE example
SET
col1 = 'new data'
, col2 = 'new data'
, col3 = col1
, col4 = col2
WHERE col1 = 'some text'
thank u.
But it will update for all the rows related to the col1=‘some text’?
or we want any loop for executing the related records?
Now i want to update the example table as;
for this i want an sql query to update like this…
Thanking you…
So you want a query that updates when col1 = ‘ex1’, but not always the same columns, and not always with the same values?
You’ll have to define the exact logic the updates must follow, and then maybe it can be done in 1 query, and maybe not.
And showing some data that actually makes sense might make it easier to understand the problem. Unless this is real data of course 
‘Example’ table:::
<table id=“table_results” class=“data”>
<thead><tr>
<th>cat_name
</th><th>subcat_name
</th><th>subcat_name1
</th><th>subcat_name2
</th></tr>
</thead>
<tbody>
<tr class=“odd”>
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Semi-rigid Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Patch Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Patch Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Tight Buffered Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class=“”>Semi-rigid Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”>SMA-Type</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”>N-Type</td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”>SMA-Type</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Loose Tube Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Loose Tube Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
</tbody>
</table>
After modifications/updations in the ‘Example’ table:::
<table id=“table_results” class=“data”>
<thead><tr>
<th>cat_name
</th><th>subcat_name
</th><th>subcat_name1
</th><th>subcat_name2
</th></tr>
</thead>
<tbody>
<tr class=“odd”>
<td class=“”>Cable Assemblies</td>
<td class=“”>Copper Cable Assemblies</td>
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Cable Assemblies</td>
<td class=“”>Copper Cable Assemblies</td>
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Semi-rigid Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Patch Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Patch Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>RF Connectors</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Tight Buffered Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class=“”>Semi-rigid Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Cable Assemblies</td>
<td class=“”>Copper Cable Assemblies</td>
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Cable Assemblies</td>
<td class=“”>Copper Cable Assemblies</td>
<td class=“”>Flexible Cable Assemblies</td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Cable Assemblies</td>
<td class=“”>Copper Cable Assemblies</td>
<td class=“”>Flexible Cable Assemblies</td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class=“odd”>
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class=“”>Others</td>
<td class=“”> </td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="odd">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Loose Tube Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
<tr class="even">
<td class=“”>Fiber Optic Cable Assemblies</td>
<td class=“”>Loose Tube Cables</td>
<td class=“”> </td>
<td class=“”> </td>
</tr>
</tbody>
</table>
I tried, but subcat_name2 has set null in the updations…
see the 4th column related to ‘Flexible Cable Assemblies’.
For this i want the query?
'Example' table:::
<table id="table_results" class="data">
<thead><tr>
<th>cat_name
</th><th>subcat_name
</th><th>subcat_name1
</th><th>subcat_name2
</th></tr>
</thead>
<tbody>
<tr class="odd">
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Semi-rigid Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Tight Buffered Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Semi-rigid Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Flexible Cable Assemblies</td>
<td class="">SMA-Type</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Flexible Cable Assemblies</td>
<td class="">N-Type</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Flexible Cable Assemblies</td>
<td class="">SMA-Type</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Loose Tube Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Loose Tube Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
</tbody>
</table>
After modifications/updations in the 'Example' table:::
<table id="table_results" class="data">
<thead><tr>
<th>cat_name
</th><th>subcat_name
</th><th>subcat_name1
</th><th>subcat_name2
</th></tr>
</thead>
<tbody>
<tr class="odd">
<td class="">Cable Assemblies</td>
<td class="">Copper Cable Assemblies</td>
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Cable Assemblies</td>
<td class="">Copper Cable Assemblies</td>
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Semi-rigid Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Patch Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">RF Connectors</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Tight Buffered Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Semi-rigid Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Cable Assemblies</td>
<td class="">Copper Cable Assemblies</td>
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Cable Assemblies</td>
<td class="">Copper Cable Assemblies</td>
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Cable Assemblies</td>
<td class="">Copper Cable Assemblies</td>
<td class="">Flexible Cable Assemblies</td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Others</td>
<td class=""> </td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="odd">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Loose Tube Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
<tr class="even">
<td class="">Fiber Optic Cable Assemblies</td>
<td class="">Loose Tube Cables</td>
<td class=""> </td>
<td class=""> </td>
</tr>
</tbody>
</table>
I tried, but subcat_name2 has set null in the updations…
see the 4th column related to ‘Flexible Cable Assemblies’.
For this i want the query?