CODEWITHSUNDEEP
mysqldatabase
Abhilash Muthuraj
Abhilash Muthuraj

Reputation: 2028

concatenating a field in mysql database?

I'm new and don't have much experience in database. I've a front end GUI flex application and saves user interactions to MySQL database.

Database will have fields like this.

ID Name ChartName SequenceOfActions rest--of--fields

I want to update the database whenever the user makes GUI change or interacts. I know the update command but it will delete older value and update.

I want something like append command which will save the values in the database.

Upvotes: 0

Views: 42

Answers (1)

jeffff
jeffff

Reputation: 1319

Are you looking for CONCAT? Something like:

UPDATE my_table SET my_field = CONCAT(my_field, 'New content');

Upvotes: 2

Related Questions