| SitePoint Sponsor |
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..
Code:SET col1 = 'new data' , col2 = 'new data' , col3 = col1 , col4 = col2
Guido - Community Team Advisor
Do you know where the (database) error is? Add it to the list!
Thinking Web: Voices of the Community
Blog - Free Flash Slideshow Widget
based on the value of col1, it will update.
If col2 is set, that value will be as col4 otherwise col4 as null..
What?Originally Posted by venkat6134
Guido - Community Team Advisor
Do you know where the (database) error is? Add it to the list!
Thinking Web: Voices of the Community
Blog - Free Flash Slideshow Widget
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';
Code:UPDATE example SET col1 = 'new data' , col2 = 'new data' , col3 = col1 , col4 = col2 WHERE col1 = 'some text'
Guido - Community Team Advisor
Do you know where the (database) error is? Add it to the list!
Thinking Web: Voices of the Community
Blog - Free Flash Slideshow Widget
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?
Example table:::
-----------------------------------
col1 col2 col3 col4
-----------------------------------
ex1 ab
-----------------------------------
ex2 abc
-----------------------------------
ex1
-----------------------------------
ex3
-----------------------------------
ex1 abc
-----------------------------------
ex1 xyz
-----------------------------------
Now i want to update the example table as;
Example table::after updations)
-----------------------------------
col1 col2 col3 col4
-----------------------------------
ex1ab abcd ex1 ab
-----------------------------------
ex2 abc
-----------------------------------
ex1ab ex1
-----------------------------------
ex3
-----------------------------------
ex1ab abcd ex1 abc
-----------------------------------
ex1ab abxyz ex1 xyz
-----------------------------------
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
Guido - Community Team Advisor
Do you know where the (database) error is? Add it to the list!
Thinking Web: Voices of the Community
Blog - Free Flash Slideshow Widget
'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?
Code HTML4Strict:'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?
Posting Permissions
Bookmarks