Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Getting Error (Invalid input 'Q': expected 't/T') while executing matching cypher query in Neo4j.
MATCH (company:COMPANY {name:'`X'SQUIRE COMMUNICATIONS PRIVATE LIMITED'}),
(cin:CORPORATE_IDENTIFICATION_NUMBER {number:'U64202TN2001PTC048084'})
CREATE (company)-[:IDENTIFIED_BY]-> (cin)
The problem is single quote (') in the data. To resolve use double quote instead of single quote(").
MATCH (company:COMPANY {name:"`X'SQUIRE COMMUNICATIONS PRIVATE LIMITED"}),
(cin:CORPORATE_IDENTIFICATION_NUMBER {number:'U64202TN2001PTC048084'})
CREATE (company)-[:IDENTIFIED_BY]-> (cin)
