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.
Jump to PostYou can just concatenate the current column value with the new input.
UPDATE table_name SET col1 = CONCAT(col1, 'new value') WHERE ID = some_id;
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...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.