I would like to know if it is possible to use rand in an insert query.
I have to create a table of about 500 users for a project allocating a
individual password for each.
I was thinking that putting a rand() in the relevant valuses area of my
mysql insert statement would do it.
Could you kind prople help with ideas or online examples.
I have created a rand password maker as a standalone script but this
dose not suit the requirements.
I think the sql would be
Insert into table set name=$name, password=rand(8,12);
Right or wrong
As always thank you for any help or guidance in advance.