随机数生成器的mysql更新错误

Question

我有下面的查询，它生成一个随机数，然后将xxxx附加到它上面。然后我将其更新到列

UPDATE users SET profile_name = concat( "xxxxx" , CONVERT(varchar(240), FLOOR( 7 + ( RAND( ) * 9999999 ) ) ) )

它抛出了以下错误。

 #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 'varchar(240), FLOOR( 7 + ( RAND( ) * 9999999 ) ) ) )' at line 1

错误是什么？

Answer 1

我认为这是可执行文件，您需要：-

SELECT CONCAT( "xxxxx" , CONVERT(FLOOR( 7 + ( RAND( ) * 9999999 ) ), CHAR ) )

Answer 2

试试这个：

UPDATE users SET profile_name = concat("xxxx", FLOOR(7 + RAND() * 9999999))