Add text query in Mysql

[bdyaniv]

Hi,

 

I would like to know what's the right Mysql query for adding text to an existing field.

for example

The field's name is "Info" and contain the text "hello"

I would like to add the text "Bye Bye" in another line so It'll be like this:

Hello

Bye Bye

 

Thanks a lot

[Guest]

its

tep_db_query("insert into " . TABLE_DEFINED_FOR_THIS_PURPOSE . " (the_text_field)VALUES ('hello world')");
tep_db_query("insert into " . TABLE_DEFINED_FOR_THIS_PURPOSE . " (the_text_field)VALUES ('bye bye world')");

assuming the table has an autoincrement column.

[bdyaniv]

its

tep_db_query("insert into " . TABLE_DEFINED_FOR_THIS_PURPOSE . " (the_text_field)VALUES ('hello world')");
tep_db_query("insert into " . TABLE_DEFINED_FOR_THIS_PURPOSE . " (the_text_field)VALUES ('bye bye world')");

assuming the table has an autoincrement column.

 

Thanks

I actually need to use the PHP_MY_ADMIN and just run the query there.

Do you know how to do it ?