/SQL/Random name function in mysql for nvarchar

Random name function in mysql for nvarchar

INSERT INTO vehicles VALUES (blah); -- leaving out the number plate
SELECT @lid:=LAST_INSERT_ID();
UPDATE vehicles SET numberplate=concat(
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@lid)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@seed)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@seed)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@seed)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@seed)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@seed)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed:=round(rand(@seed)*4294967296))*36+1, 1),
  substring('ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', rand(@seed)*36+1, 1)
)
WHERE id=@lid;

Source: stackoverflow.com

Similar codes

0 vote242 views1 answer
Datagrip exec
SQL
3 votes183 views2 answers
Mysql add 2 hours
SQL
10 votes205 views2 answers
Forgot my mysql password mac
SQL
1 vote188 views1 answer
Postgres set column equal to another
SQL
-2 votes198 views3 answers
Sqlite reset autoincrement
SQL
0 vote193 views1 answer
Limit and offset in stored procedure mssql
SQL
4 votes197 views1 answer
Mysql not equal
SQL
3 votes201 views2 answers
Laravel tosql with bindings
SQL
0 vote262 views1 answer
Mariadb used space
SQL
3 votes185 views1 answer
How to remove characters from string in mysql
SQL