Error report of sql concat

Question

Choose from the options below and concatenate the "city" and "state" columns, separated by commas, into a new custom column called "new_address".

SELECT ___()____ new_address FROM customers;

This is how I filled it out

SELECT concat(city,',',state) as new_address FROM customers;

But it’s still wrong

P粉880818043 · Answer

Do you have an answer? This is the same, English doesn’t work either

陈磊 · Answer

The statement itself should be fine, check whether the entered comma is a comma in English mode

autoload · Answer

The concat function does not have the function of specifying a connector when connecting strings. You can use concat_ws. The above example is

select concat_ws(',',city,state)  as   new_address from customers;