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.