updating/appending to mysql

[robin01]

Hello everybody,


I need information or tutorial on appending data to existing field in a database.
I looked up information on it but little confused.. is "updating" adding to the existing data or does it replace the existing data in a field.

any ideas or site that can give me some ideas on how append to existing data would be greate...examples even better...

Thanks everybody..
Robin

[SJH]

Updating replaces the existing data in a field.

An UPDATE query would look something like:

UPDATE table SET field = 'Somevalue', field2 = 'Anothervalue' WHERE condition;

However this query will only change the values of the fields 'field' and 'field2'. Any other fields that exist in that table would remain unchanged.

Hope this helps

-Sam

[robin01]

Hi Devilware.net..
I tried the statement and it replaced the content of the field insted of adding to the field..need somthing to append..

[jobe]

robin01, if you don't want to replace the data already in the database, then you should use INSERT rather than UPDATE.

Insert will add a completely new row to the database with the provided data.

If however, you want to append to the data already stored in the field you can use the concat() to do so (in MySQL at least):

UPDATE test SET name = concat("Mr. ",name) WHERE ID = 1

That would add "Mr. " to the start of the name of the person with ID number 1.
- Ethan

Edit: had to fix my incredibly bad example

[zoki]

Althought widely used in php, this has nothing to do with php directly. It belongs to mysql forum