/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

4 votes105 views2 answers
Oracle set date format
SQL
0 vote99 views2 answers
Postgres default user
SQL
8 votes100 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote103 views1 answer
Object Information
SQL
0 vote113 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote103 views1 answer
Transaction and commit trong sql server
SQL
0 vote110 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote141 views2 answers
How to login to mysql as normal user in ubuntu
SQL
4 votes113 views3 answers
Sql drop primary key
SQL
0 vote120 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL