using rand() in multiple insert ?
| From: | Dave Carrera | Date: | Sun, 07 Jul 2002 12:06:29 +0000 |
| Subject: | using rand() in multiple insert ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20355@lists.php.net to get a copy of this message | ||
Hi All
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.
Dave C