multi-line infomation in mysql field

[raman]

I have a table in mysql database which I had initially written as an excel file and then imported into mysql command by saving it as a csv file and then using load data local ...command.

Now I want to add a new field to the database but the problem is that the information extends into multple lines.I exemplify below:

 

AAAAAFFFGGVVVVVVVVV 23 34 45 67

CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCNNNNNVVVV 56 76 23 90

SSSSSSSSSS 45 34 65 43

 

Against the total 1775 entries in the table around 1000 entries would have this type of information.

 

Is there any way to store this type of information ?Also the number of lines is not fixed for every entry ,it varies with every entry.

[rhodesa]

you should use mysql_real_escape_string() on all your values before putting into the SQL Query. it will escape the data properly

[raman]

could you elaborate how I can incorporatethe field into the table? I am sure it won't begin from Excel sheet ,bu would be loaded from a text file only .

But will you please explain i detail?

[Maq]

Is there any way to store this type of information ?Also the number of lines is not fixed for every entry ,it varies with every entry.

 

Yes there is.  Can we see the code of insertion so we can give you specific help?