Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH DataCTE AS (
- SELECT
- generate_series(1, 5000000) as id,
- FLOOR(RANDOM()*(20 - 1) + 1)::int as quantity,
- FLOOR(RANDOM()*(4000000 - 1) + 1)::int as item_id,
- FLOOR(RANDOM()*(5000000 - 1) + 1)::int as order_id
- )
- INSERT INTO shop_orderitem
- SELECT
- DataCTE.id,
- DataCTE.quantity,
- DataCTE.item_id,
- DataCTE.order_id
- FROM DataCTE
- WHERE NEXTVAL('query_progress') != 0;
Advertisement
Add Comment
Please, Sign In to add comment