Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Insert into ... values not working (console) #2920

Closed
matgames opened this issue Oct 13, 2014 · 1 comment
Closed

Insert into ... values not working (console) #2920

matgames opened this issue Oct 13, 2014 · 1 comment

Comments

@matgames
Copy link

Issue: trying to issue a 'insert into' command, with values field, does not insert the data.
Reproduce:

  1. Use the console and connect to the database (remote tested only)
  2. issue the following command:
    orientdb> INSERT INTO CData VALUES ('0', '153', 'Jon@gmail.com', '12354');

Inserted record '[]' in 0.001000 sec(s).

orientdb> select from CData

0 item(s) found. Query executed in 0.001 sec(s).

executing an insert into with set does work:
orientdb> INSERT INTO CData set pass_Id=0, future_date=153, email='Jon@gmail.com', code='12345'

Inserted record 'CData#13:0{pass_id:0,future_date:Thu Jan 01 02:00:00 IST 1970,email:Jon@gmail.com,code:12345} v1' in 0.006000 sec(s).

orientdb> select from CData
----+-----+-------+-------------------+------------+------

|@Rid |pass_id|future_date |email |code

----+-----+-------+-------------------+------------+------
0 |#13:0|0 |1970-01-01 02:00:00|Jon@gmail.com|12345
----+-----+-------+-------------------+------------+------

@andrii0lomakin
Copy link
Member

That is because you do not write field names during insert , please look at https://github.com/orientechnologies/orientdb/wiki/Console-Command-Insert

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants