Hi,

I am wondering that May I use any context variables in INSERT INTO...FROM 
SELECT?

For example,

INSERT INTO EntityA FROM (SELECT propB1 as propA1, num_record_inserted as 
propA2, eval("num_record_inserted % 100") as propA3 FROM EntityB)

I assume that num_record_inserted is a context variable that represents for 
the number of records inserted. The expected result is

TableA
------------------------------------------------------------
RecordId, propA1, propA2, propA3
------------------------------------------------------------
#20:1, 'A', 1, 1
#20:2, 'A', 2, 2
#20:3, 'A', 3, 3
...
#20:101, 'A', 101, 1
....

Any help will be really appreciated!

My Best,
Hung Tran

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to