/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

3 votes116 views2 answers
Oracle for loop
SQL
9 votes125 views1 answer
Oracle get table schema
SQL
9 votes124 views6 answers
Sql add column with default value
SQL
1 vote71 views1 answer
Mysql collation
SQL
0 vote117 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
21 votes120 views3 answers
Sql server search column name in all tables
SQL
13 votes125 views1 answer
Sql join 3 tables on id
SQL
0 vote123 views1 answer
Laravel eloquent get generated sql
SQL
5 votes116 views1 answer
Find table from column name in sql
SQL
0 vote72 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL