/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

1 vote180 views1 answer
Is sql fast
SQL
0 vote195 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote142 views1 answer
Postgres read table structure
SQL
0 vote148 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote138 views1 answer
Select statement to print longest name
SQL
0 vote146 views1 answer
Pip install mysqlclient error
SQL
8 votes118 views1 answer
Oracle current date plus 1 month
SQL
3 votes139 views1 answer
How to remove characters from string in mysql
SQL
0 vote171 views1 answer
Drop table BigQuery table columns
SQL
1 vote173 views1 answer
Hangfire clear all jobs
SQL