Join strings in qql update query

Question

i have two fields with a string in it, and i want a combination of those in a third field like:

UPDATE table SET field3=field1 . '_' . field2

what would be the right syntax for that? it is mysql

okay that CONCAT Thing worked, is there a function to convert those fields to lowercase??

Answer 1

In SQL Server:

UPDATE table SET field3 = field1 + '._.' + field2

Answer 2

What is your DBMS ? This could work :

UPDATE table SET field3=field1 || '_' || field2

in Oracle. In fact, '||' is the ANSI-SQL concatenation operator.

Answer 3

It depends on the database management system. In sql server would be:

UPDATE table SET field3 = field1 + '_' + field2

Whereas in Mysql it can be done with:

UPDATE table SET field3 = CONCAT_WS ('_', field1, field2)