/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

-2 votes308 views1 answer
Modify column name in tsql
SQL
5 votes296 views1 answer
List foreign key oracle
SQL
3 votes292 views1 answer
What is having clause
SQL
10 votes301 views3 answers
Insert into auto increment mysql
SQL
0 vote316 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote311 views1 answer
Sqlalchemy query join many to many
SQL
3 votes317 views1 answer
Oracle apex call duration
SQL
0 vote290 views1 answer
How to check replication lag in mySQL
SQL
4 votes301 views2 answers
Error loading MySQLdb module.
SQL
9 votes341 views2 answers
SELECT User,Host FROM mysql.user;
SQL