There are two tables with the same structure: Id int, Type int, Data blob It is necessary in the second table to select the first 10 records for each Type and change it with random data in the Data fields from the first table with the same Type. Is it possible to do this with queries, or do we need to use cycles?
- number of records approximately what in the tables? - sterx
- "first 10 records" - by what principle to sort? - Yuriy Prokopets
- in the first about 100k, in the second 10k - Alex Mayboroda
- sort by id - Alexey Mayboroda
- And how many unique type? - Yuriy Prokopets
|