insert Mutiplos data already having data in db

Asked

Viewed 30 times

1

Great, I’m having a problem adding values to db. I want to add a value in a field that already has a value, without eliminating the value that is there, but by joining the two values separated by a comma. I know it has something to do with implode, but I’ve tried a lot of things and it doesn’t work.

  • I select the db of the value and include it in an implode and enter it in the right db

  • I’ll try thank you

  • Your column on the bench is like varchar?

  • yes, it is varchar but the next answer solved the problem

1 answer

2


I think that solves:

UPDATE tabela SET coluna = CONCAT(coluna , ',' , novovalor) WHERE coluna = x

Browser other questions tagged

You are not signed in. Login or sign up in order to post.