Insert not working

CREATE VERTEX Person (
PRIMARY_ID perid STRING,
name STRING,
age INT,
gender STRING,
state STRING
)
– Successfully created.
Trying to insert details using insert statement, which is not working.

INSERT INTO Person ( perid , name, age, gender, state ) VALUES ( ‘1’,‘Tom Riley’,43 ,‘Male’,‘CA’);

Any help is greatly appreciated.

Hi @Solai_Srinivasan I was looking to replicate your code a bit. Can you try the suggested code below?

Can you try the following:

INTERPRET QUERY () FOR GRAPH Customer {
INSERT INTO Person VALUES ( ‘1’,‘Tom Riley’,43 ,‘Male’,‘CA’);
}

Try proper double quotes ?

1 Like

Hi @Solai_Srinivasan

Kindly try the following query:

INTERPRET QUERY () FOR GRAPH Graph_name{
INSERT INTO Person VALUES ( “1”,“Tom Riley”,43 , “Male”, “CA”);
}

This should work for you.

1 Like

@Solai_Srinivasan Did the double quotes solve the issue?

Thanks Sandya, and Herke. I have the same issues.

No Herke. same issue. Replied to other post. Thanks for your help, issue still persists.

@Solai_Srinivasan It looks good syntactically. Is your graph name called customer? Do you need to switch Graph_name to Customer?

Yes Jon. I changed the graph name to Customer, but no luck. I didnt have these issues in neo4j. wondering if I am making any other mistakes here, as tried with different quotes single and double from my keyboard.

Attached insert images both with grap_name as well as Customer in my earlier reply. I am in the tiger-graph cloud free sandbox. Thanks much for your help and support.