Hi Guilia,
I am already doing this. The question I had was about spreading
individual inserts across more than one line. In other words this:
insert into User(name, emailAddress)
values ("Joe", "[email protected]");
As opposed to this:
insert into User(name, emailAddress) values ("Joe", "[email protected]");
When I include a line break it does not work. Some of the inserts are
quite long and it would be nice to be able to break them up across lines.
Incidentally, I have no semicolons in my osql file and it seems to work
fine, but maybe that's the problem?
Thanks!
Chas.
On 8/17/15 7:33 PM, Giulia Brignoli wrote:
Hi Charles,
if you have already created the database with classes and want to do
only the insertion through the file .osql, then you must create the
file myscritp.osql in the bin folder of OrientDB like this:
|
connect remote:localhost/testScript admin admin;
insert into User(name, emailAddress) values ("Joe","[email protected]);
insert into User(name, emailAddress) values ("Bob","[email protected]);
insert into User(name, emailAddress) values ("Mike","[email protected]);
...
|
Then, after you create this file, access to the bin folder from the
command line and run the following command:
|
console.bat myscript.osql
|
and this automatically performs the insertion of data.
Regards,
Giulia
--
---
You received this message because you are subscribed to a topic in the
Google Groups "OrientDB" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/orient-database/dQg8ZbeiWAQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
[email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
---
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.
