如何在MYSQL中将整个字符串小写并保持第一个大写[重复]

我的表栏目-

我预期的输出会在列中发生变化 -

Smith, Allen, Doyle, Dennis, Baker, Waker

这是我尝试过的，但不起作用:( -

UPDATE TABLE `employee`
SET last_name = UCASE(LEFT(lower(last_name), 1))

UPDATE TABLE `employee`
SET last_name = ucase(lower(last_name),1)

也关注了这个链接 -Resource https://stackoverflow.com/questions/4263272/capitalize-first-letter-mysql

ERROR --

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `employee` SET last_name = UCASE(LEFT(lower(last_name), 1))' at line 1

让我知道我做错了什么以及如何解决。

TABLE是保留关键字。应该用反引号对其进行转义。

I think TABLE不应出现在您的查询中，(我认为这是一个错字)

UPDATE employee
SET last_Name = CONCAT(UCASE(LEFT(last_Name, 1)), LCASE(SUBSTRING(last_Name, 2)))

• SQLFiddle 演示 http://sqlfiddle.com/#!2/a7dc0/1