Menu
I tried to run this query in SQL server:
update ABC set data = concat(data, 'a');
this returns: concat is not a built in function
494
Here each user posts are different so we can't apply any update command so we will use concat to add the site signature to each post kept inside a record field in our update command. Now let us see how it is used in a MySQL table query.
To append a string to another and return one result, use the || operator. This adds two strings from the left and right together and returns one result. If you use the name of the column, don't enclose it in quotes. However, in using a string value as a space or text, enclose it in quotes.
Make sure your database is in compatibility level 110, otherwise you can use the old style concat:
UPDATE ABC
SET data = data + 'a'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
