SitePoint Sponsor

User Tag List

Results 1 to 11 of 11
  1. #1
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to update same table columns?

    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..

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,509
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Code:
    SET
        col1 = 'new data'
      , col2 = 'new data'
      , col3 = col1
      , col4 = col2

  3. #3
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    based on the value of col1, it will update.
    If col2 is set, that value will be as col4 otherwise col4 as null..

  4. #4
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,509
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Quote Originally Posted by venkat6134 View Post
    based on the value of col1, it will update.
    If col2 is set, that value will be as col4 otherwise col4 as null..
    What?

  5. #5
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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';

  6. #6
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,509
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Code:
    UPDATE example
    SET
        col1 = 'new data'
      , col2 = 'new data'
      , col3 = col1
      , col4 = col2
    WHERE col1 = 'some text'

  7. #7
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?

  8. #8
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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...

  9. #9
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,509
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    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

  10. #10
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    '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="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">Flexible Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Semi-rigid Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>

    <td class="">Patch Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Patch Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Patch Cables</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    </tr>

    <tr class="odd">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Tight Buffered Cables</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Semi-rigid Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">Flexible Cable Assemblies</td>
    <td class="">SMA-Type</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Flexible Cable Assemblies</td>
    <td class="">N-Type</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Flexible Cable Assemblies</td>
    <td class="">SMA-Type</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Others</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>

    <td class="">Loose Tube Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Loose Tube Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</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="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">Cable Assemblies</td>
    <td class="">Copper Cable Assemblies</td>
    <td class="">Flexible Cable Assemblies</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Semi-rigid Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>

    <td class="">Patch Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Patch Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Patch Cables</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">RF Connectors</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">RF Connectors</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    </tr>

    <tr class="odd">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Tight Buffered Cables</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Semi-rigid Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">Cable Assemblies</td>
    <td class="">Copper Cable Assemblies</td>
    <td class="">Flexible Cable Assemblies</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Cable Assemblies</td>
    <td class="">Copper Cable Assemblies</td>
    <td class="">Flexible Cable Assemblies</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Cable Assemblies</td>
    <td class="">Copper Cable Assemblies</td>
    <td class="">Flexible Cable Assemblies</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Others</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">

    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>
    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>

    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Others</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="odd">
    <td class="">Fiber Optic Cable Assemblies</td>

    <td class="">Loose Tube Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</td>
    </tr>

    <tr class="even">
    <td class="">Fiber Optic Cable Assemblies</td>
    <td class="">Loose Tube Cables</td>
    <td class="">&nbsp;</td>
    <td class="">&nbsp;</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?

  11. #11
    SitePoint Evangelist venkat6134's Avatar
    Join Date
    Jul 2010
    Posts
    455
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">Flexible Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Semi-rigid Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
     
    <td  class="">Patch Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Patch Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Patch Cables</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
    </tr>
     
        <tr class="odd">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Tight Buffered Cables</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Semi-rigid Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">Flexible Cable Assemblies</td>
    <td  class="">SMA-Type</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Flexible Cable Assemblies</td>
    <td  class="">N-Type</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Flexible Cable Assemblies</td>
    <td  class="">SMA-Type</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Others</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
     
    <td  class="">Loose Tube Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Loose Tube Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</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="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">Cable Assemblies</td>
    <td  class="">Copper Cable Assemblies</td>
    <td  class="">Flexible Cable Assemblies</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Semi-rigid Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
     
    <td  class="">Patch Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Patch Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Patch Cables</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">RF Connectors</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">RF Connectors</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
    </tr>
     
        <tr class="odd">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Tight Buffered Cables</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Semi-rigid Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">Cable Assemblies</td>
    <td  class="">Copper Cable Assemblies</td>
    <td  class="">Flexible Cable Assemblies</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Cable Assemblies</td>
    <td  class="">Copper Cable Assemblies</td>
    <td  class="">Flexible Cable Assemblies</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Cable Assemblies</td>
    <td  class="">Copper Cable Assemblies</td>
    <td  class="">Flexible Cable Assemblies</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Others</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
     
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
     
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Others</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="odd">
    <td  class="">Fiber Optic Cable Assemblies</td>
     
    <td  class="">Loose Tube Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</td>
    </tr>
     
        <tr class="even">
    <td  class="">Fiber Optic Cable Assemblies</td>
    <td  class="">Loose Tube Cables</td>
        <td class="">&nbsp;</td>
        <td class="">&nbsp;</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?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •