I have sets of data that i want to put in tables, however the data is big and want to put it in different rows, something like
have a table like

MSISN DBSG OSB1 OSB3 BS2G BS3G TS11 TS21 TS22 CSP NAM
256392999829 1 1 1 1 1 1 1 1 9 0

and all the other parameters

**HGSUI:IMSI=641102939299829,MSISDN=256392999829;
HGSDC:MSISDN=256392999829,SUD=CAT-10&DBSG-1&OSB1-1&OSB3-1&BS2G-1&BS3G-1&TS11-1&TS21-1&TS22-1&CSP-9&NAM-0&SCHAR-4&REDMCH-1&PWD-0000&OFA-1&OICK-120&HOLD-1&MPTY-1&CLIP-1&CFU-1&CFNRY-1&CFNRC-1&BAOC-1&BOIC-1&BOIEXH-1&BAIC-1&CAW-1&SOCFU-0&SOCFB-0&SOCFRY-1&SOCFRC-0&SODCF-0&SOSDCF-7&SOCB-1&SOCLIP-0&SOCLIR-0&SOCOLP-0
HGSUI:IMSI=641102939299828,MSISDN=256392999828;
HGSDC:MSISDN=256392999828,SUD=CAT-10&DBSG-1&OSB1-1&OSB3-1&BS2G-1&BS3G-1&TS11-1&TS21-1&TS22-1&CSP-8&NAM-0&SCHAR-4&REDMCH-1&PWD-0000&OFA-1&OICK-26&HOLD-1&MPTY-1&CLIP-1&CFU-1&CFNRY-1&CFNRC-1&BAOC-1&BOIC-1&BOIEXH-1&BAIC-1&CAW-1&SOCFU-0&SOCFB-0&SOCFRY-1&SOCFRC-0&SODCF-0&SOSDCF-7&SOCB-1&SOCLIP-0&SOCLIR-0&SOCOLP-0;

**

u can use normal insert into table name values(' ');but learn datatypes

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.