Member Avatar for Smooth_1

hi... im trying to update one of the columns of my table with a multiple data without deleting the previous data.. by the way im using vb.net and mysql... does anyone has an idea? or a codes perhaps.

its like, the previous data being inserted will just merge from the new inserted one.

Edited by Smooth_1
  • 2 Contributors
  • 2 Replies
  • 350 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by Smooth_1
Member Avatar for hericles

You can just concatenate the current column value with the new input.
UPDATE table_name SET col1 = CONCAT(col1, 'new value') WHERE ID = some_id;

Member Avatar for Smooth_1

thanks hericles..i got it...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.