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.

Recommended Answers

All 2 Replies

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;

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, learning, and sharing knowledge.