/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

5 votes236 views2 answers
Postgres update with if condition query
SQL
2 votes218 views1 answer
Import database in mysql command line xampp
SQL
1 vote217 views1 answer
Sql bitwise operators
SQL
0 vote316 views1 answer
Compare strings lexicographically in sql
SQL
0 vote235 views1 answer
Oracle table free space
SQL
0 vote213 views1 answer
Dasebase_url-postgres for windows
SQL
0 vote251 views1 answer
How to find symmetric pairs in sql
SQL
0 vote231 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote174 views1 answer
Ms sql print more than 1 variable
SQL
1 vote253 views1 answer
Insert pg result of select
SQL