I have a sqlite table like this:
id      name                                            mnote                   
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-BASSE    AA34695081                      
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

Reply via email to