Latest news
Home » SQL » mysql concatenate update query

mysql concatenate update query

We can append datat to the existing data in mysql field. Column name is email and value is “info@smarttips.com”

UPDATE `engine4_users` SET email = CONCAT( email, ‘_test’ )

After the query execution the _test dat will be appended to email

Output:info@smarttips.com_test

Leave a Reply

x

Check Also

How can be list the installed SQL Server instances

Press window+R windows run window will open and then type cmd Command prompt will open ...