Re: [sqlite] about merge rows

2014-04-17 Thread mm.w 
@hello,

it looks like an old sybase
-ms-flatten-like
export, if I understand well you got that just after splitting then
pivoting the properties, am I wrong?


On Thu, Apr 17, 2014 at 6:43 PM, Igor Tandetnik  wrote:

> On 4/17/2014 9:26 PM, YAN HONG YE wrote:
>
>> I want to merge all the mnote, how to do this?
>>
>
> What do you mean "merge"? What should the table look like afterward?
> --
> Igor Tandetnik
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] about merge rows

2014-04-17 Thread Igor Tandetnik 

On 4/17/2014 9:26 PM, YAN HONG YE wrote:

I want to merge all the mnote, how to do this?


What do you mean "merge"? What should the table look like afterward?
--
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] about merge rows

2014-04-17 Thread YAN HONG YE 
I have a sqlite table like this:
id  namemnote   
7   DDD_POSTE_DE_COND   
2;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000

2;7903233029.1;;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000

3;9807260277.1;;AA36766417.1;DDD;COMMU-REGU-LIMI-VITE;001

4;9665586177.1;;AA36284384.1;DDD;COMMU-REGU-LIMI-VITE;001

5;9675673177.1;;AA36049484.1;DDD;BLOC-COMMU-COMM-BVMP;003

6;9663123380.1;;AA35651299.1;DDD;ANTENN-ELECTR-TRANSP;001DDD_POSTE_DE_COND


8   ASSISE-BASSEAA34695081  
14;9807054180.1;;AA36305186.1;DDD;BOITIE-SERVIT-INTELL;002

15;9801195980.1;;AA37380334.1;DDD;SUPPOR-BOITIE-SERVIT;000

16;9805077080.1;;AA36701967.1;DDD;BOITIE-COMMAN-CLIMAT;003

17;9804790880.1;;AA36696339.1;DDD;CAPT-DET-CHO-MOY-RET;001

18;9804790880.1;;AA36696338.1;DDD;CAPT-DET-CHO-MOY-RET;001


9   FAISCEAUX-ELEC-PDC  
1;9807698080.1;;AA35538582.1;DDD;GOUT-TAB-INF-FAI-HAB;000

2;9803453480.1;;AA35574764.1;DDD;GOUTT-TUNN-FAIS-HABI;000

3;9803453480.1;;AA35538573.1;DDD;GOUTT-TUNN-FAIS-HABI;000

4;9681595580.1;;AA36168981.1;DDD;ECR-HXEMBBOR5X160PLA;002

5;9681595580.2;;AA36168981.1;DDD;ECR-HXEMBBOR5X160PLA;002

6;967352338A.1;;AA35568067.1;DDD;MODU-LOC-ALA-ANT-VOL;004

I want to merge all the mnote, how to do this?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users