> It looks as if you are being over-complex anyway. Isn't what you want
> 
> SELECT * FROM PARTITIONED_B ORDER BY RAND() LIMIT 1 ;
> 
> which picks a single random record.


No, I have to know which is the ID I pick before doing the select
(because I splitted my data, and when I access the splitted table
I have code like:

int table = ((m / 2000000) + 1);
String query = "SELECT * FROM PARTITIONED_B_" + table + " WHERE ID=?";
)


Thank you anyway



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to